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.

Related content

BITRSHIFT
BITAND
BITOR
BITXOR