ABS DAX Function (Math and Trig)

Syntax  |  Return values  |  Remarks  |  Examples  

Returns the absolute value of a number.

Syntax

ABS ( <Number> )

Parameter	Attributes	Description
Number		The number for which you want the absolute value.

Return values

Scalar A single value of one these types: currency, decimal, integer.

Remarks

The absolute value of a number with the same data type and without its sign.
It also works with positive and negative infinite numbers.

Examples

--  ABS returns the absolute value of a number
--  SIGN returns:
--      +1 if the number is positive
--       0 if the number is zero
--      -1 if the number is negative
DEFINE
    VAR Vals = GENERATESERIES ( -2, +2, 0.5 )
EVALUATE
ADDCOLUMNS ( 
    Vals, 
    "ABS", ABS ( [Value] ), 
    "SIGN", SIGN ( [Value] )
)
ORDER BY [Value] DESC

Value	ABS	SIGN
2.00	2.00	1
1.50	1.50	1
1.00	1.00	1
0.50	0.50	1
0.00	0.00	0
-0.50	0.50	-1
-1.00	1.00	-1
-1.50	1.50	-1
-2.00	2.00	-1

Last update: Nov 28, 2023   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber

Microsoft documentation: https://docs.microsoft.com/en-us/dax/abs-function-dax