BITLSHIFT
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns a number shifted left by the specified number of bits.
Syntax
BITLSHIFT(<Number>, <Shift_Amount>)
Parameters
| Term | Definition |
|---|---|
| Number | Any DAX expression that returns an integer expression. |
| Shift_Amount | Any DAX expression that returns an integer expression. |
Return value
An integer value.
Remarks
- Be sure to understand the nature of bitshift operations and overflow/underflow of integers before using DAX bitshift functions.
- If Shift_Amount is negative, it will shift in the opposite direction.
- If absolute value of Shift_Amount is larger than 64, there will be no error but will result in overflow/underflow.
- There’s no limit on Number, but the result may overflow/underflow.
Examples
Example 1
The following DAX query:
EVALUATE
{ BITLSHIFT(2, 3) }
Returns 16.
Example 2
The following DAX query:
EVALUATE
{ BITLSHIFT(128, -1) }
Returns 64.
Example 3
The following DAX query:
Define
Measure Sales[LeftShift] = BITLSHIFT(SELECTEDVALUE(Sales[Amount]), 3)
EVALUATE
SUMMARIZECOLUMNS(
Sales[Amount],
"LEFTSHIFT",
[LeftShift]
)
Shifts left each sales amount with 3 bits and returns the bit-shifted sales amount.