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
: Anumber
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
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy