Binary Archives - Phil Seamark on DAX

DAX: Bitwise calculations

October 3, 2019October 3, 20194 Comments

As an extension to my recent article on base conversions in DAX, I thought I’d show how these conversion calculations can be used to help you perform bitwise calculations in DAX. At present, there are no bitwise operators in DAX (I’m working on it!!), so calculations that need to perform AND, OR, XOR, NOT etc. … Continue reading DAX: Bitwise calculations

DAX: Base conversions

October 2, 2019October 17, 20192 Comments

I was doing some work recently which required DAX calculations to convert values from a specific base to another, e.g. to convert a value in hexadecimal format to a base 10 representation (or decimal), or from base 10 to binary. Excel, like other languages has native functions to allow you to convert across base, such … Continue reading DAX: Base conversions