Edit

Share via

BITLSHIFT

  • Article

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.

Related content

BITRSHIFT BITAND BITOR BITXOR