Updated on

Number.Abs is a Power Query M function that calculates the absolute value of a given number. The function returns the absolute value of the number or null if the input is null.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Number.Abs( number as nullable number ) as nullable number


Returns the absolute value of number. If number is null, Number.Abs returns null.

  • number: A number for which the absolute value is to be calculated.


Absolute value of -3.

// Output: 3
Number.Abs( -3 )

Other functions related to Number.Abs are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: