Number.Abs

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

Syntax

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

Description

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.

Examples

Absolute value of -3.

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

Related functions

Other functions related to Number.Abs are:

• Number.Combinations
• Number.Exp
• Number.Factorial
• Number.IntegerDivide
• Number.Ln
• Number.Log
• Number.Log10
• Number.Mod
• Number.Permutations
• Number.Power
• Number.Sign
• Number.Sqrt

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/number-abs
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.