Number.Sign
Which side of zero a number is on: -1, 0 or 1.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.Sign(number as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
number | nullable number | The number to work on; null gives null. |
Returns
nullable number. -1 below zero, 0 for zero, 1 above zero; null for null.
Examples
A loss
Number.Sign(-12.5)-1The direction of each month's change
List.Transform({-40, 0, 25}, each Number.Sign(_)){-1, 0, 1}Down, flat, up.