Number.Abs
A number without its minus sign: how far it lies from zero.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.Abs(number as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
number | nullable number | The number to work on; null gives null. |
Returns
nullable number. The number itself when it is zero or more, the same number made positive otherwise.
Examples
A refund as an amount
Number.Abs(-12.5)12.5Stock changes by their size
A count went down by 3, stayed, then went up by 4.5.
List.Transform({-3, 0, 4.5}, each Number.Abs(_)){3, 0, 4.5}