Number.BitwiseXor
Combines two whole numbers bit by bit, keeping the bits set in one of them but not both.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.BitwiseXor(number1 as nullable number, number2 as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
number1 | nullable number | A whole number. |
number2 | nullable number | Another whole number. |
Returns
nullable number. The bits where the two numbers differ; null when either is null.
Examples
Where two flag sets differ
Number.BitwiseXor(12, 10)612 is 1100 and 10 is 1010: they differ in the 4 and 2 bits.
Switch the express flag (2) off again
Number.BitwiseXor(7, 2)5