OpenBI Docs Buy

Number.BitwiseShiftLeft

Moves a whole number's bits to the left: each step doubles it.

Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

Number.BitwiseShiftLeft(number1 as nullable number, number2 as nullable number) as nullable number
ParameterTypeDescription
number1nullable numberThe whole number to shift.
number2nullable numberHow many bits to move it.

Returns

nullable number. The number times 2 to the power of the shift; null when either is null.

Examples

One, shifted three places

Number.BitwiseShiftLeft(1, 3)
8

Three, shifted four places

Number.BitwiseShiftLeft(3, 4)
48

Number.BitwiseShiftRight, Number.Power.

Last updated · OpenBI Studio 0.3.79