Data Analysis Expressions (DAX) is a collection of functions and operators used to create formulas and expressions in Power BI, Power Pivot and Analysis Services. DAX helps analysts perform calculations, advance data analysis and create dynamic reports from datasets.
- Used in Power BI, Power Pivot and Analysis Services
- Creates formulas, calculations and custom expressions
- Improves report creation and business insights
- Provides around 200 functions and operators for analysis
DAX Bitwise Functions
Let's practice new Bitwise DAX functions on a sample Dataset.
DAX BITAND Function
The BITAND function performs a bitwise AND operation between two integers and returns the result.
Syntax:
BITAND(<number>, <number>)
- Number: Any DAX expression that yields an expression with an integer value.
- Shift_Amount: Any DAX expression that produces an expression of an integer.
Example: bit and = BITAND(2,30)
DAX BITLSHIFT Function
The BITLSHIFT function shifts the bits of an integer to the left by a specified number of positions and returns the resulting integer.
Syntax:
BITLSHIFT(<Number>, <Shift_Amount>)
- Number: Any DAX expression that yields an expression with an integer value.
- Shift_Amount: Any DAX expression that produces an expression of an integer.
Example: bit lshift = BITLSHIFT(2,45)
DAX BITOR Function
The BITOR function performs a bitwise OR operation between two numbers and returns the result.
Syntax:
BITOR(<number>, <number>)
- number: Any scalar expression with a numeric result. It is shortened if it is not an integer.
Example: bit or = BITOR(8,260)
DAX BITRSHIFT Function
The BITRSHIFT function shifts the bits of an integer to the right by a specified number of positions and returns the resulting value.
Syntax:
BITRSHIFT(<Number>, <Shift_Amount>)
- Number: Any DAX expression that yields an expression with an integer value.
- Shift_Amount: Any DAX expression that produces an expression of an integer.
Example: bit rshift = BITRSHIFT(8,260)
DAX BITXOR Function
The BITXOR function performs a bitwise XOR (exclusive OR) operation between two numbers and returns the result.
Syntax:
BITXOR(<number>, <number>)
- number: Any scalar expression with a numeric result. It is shortened if it is not an integer.
Example: bit xor = BITXOR(2,45)
