Edit

Share via

BITRSHIFT

  • Article

Applies to: Calculated column Calculated table Measure Visual calculation

Returns a number shifted right by the specified number of bits.

Syntax

BITRSHIFT(<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 
    { BITRSHIFT(16, 3) }

Returns 2.

Example 2

The following DAX query:

EVALUATE 
    { BITRSHIFT(1024, -3) }

Returns 8192.

Example 3

The following DAX query:

Define 
    Measure Sales[RightShift] = BITRSHIFT(SELECTEDVALUE(Sales[Amount]), 3)

EVALUATE 
SUMMARIZECOLUMNS(
    Sales[Amount],
    "RIGHTSHIFT", 
    [RightShift]
)

Shifts right each sales amount with 3 bits and returns the bit-shifted sales amount.

Related content

BITLSHIFT BITAND BITOR BITXOR