BITRSHIFT DAX Function
Returns a number shifted right by the specified number of bits.
Syntax
Parameter | Attributes | Description |
---|---|---|
Number |
Any expression that represents an integer. |
|
ShiftAmount |
Any expression that represents an integer as the number of bits to be shifted. |
Examples
DEFINE VAR Vals = GENERATESERIES ( -5, 5 ) EVALUATE ADDCOLUMNS ( Vals, "BITLSHIFT 1", BITLSHIFT ( [Value], 1 ), "BITLSHIFT 2", BITLSHIFT ( [Value], 2 ), "BITLSHIFT 3", BITLSHIFT ( [Value], 3 ), "BITRSHIFT 1", BITRSHIFT ( [Value], 1 ), "BITRSHIFT 2", BITRSHIFT ( [Value], 2 ), "BITRSHIFT 3", BITRSHIFT ( [Value], 3 ) )
Value | BITLSHIFT 1 | BITLSHIFT 2 | BITLSHIFT 3 | BITRSHIFT 1 | BITRSHIFT 2 | BITRSHIFT 3 |
---|---|---|---|---|---|---|
-5 | -10 | -20 | -40 | -3 | -2 | -1 |
-4 | -8 | -16 | -32 | -2 | -1 | -1 |
-3 | -6 | -12 | -24 | -2 | -1 | -1 |
-2 | -4 | -8 | -16 | -1 | -1 | -1 |
-1 | -2 | -4 | -8 | -1 | -1 | -1 |
0 | 0 | 0 | 0 | 0 | 0 | 0 |
1 | 2 | 4 | 8 | 0 | 0 | 0 |
2 | 4 | 8 | 16 | 1 | 0 | 0 |
3 | 6 | 12 | 24 | 1 | 0 | 0 |
4 | 8 | 16 | 32 | 2 | 1 | 0 |
5 | 10 | 20 | 40 | 2 | 1 | 0 |
Last update: Jun 17, 2022 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/bitrshift-function-dax