BITRSHIFT

Updated on
Rick de Groot

BITRSHIFT is a DAX function that returns a number shifted right by a specified number of bits.

Syntax

BITRSHIFT(
   Number,
   ShiftAmount
)
Argument Properties Description
Number Any expression that represents an integer.
ShiftAmount Any expression that represents an integer as the number of bits to be shifted.

Return Values

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.

Other functions related to BITRSHIFT are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/bitrshift-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy