## How does the ABS function (DAX) work?

The ABS function (DAX) returns a number’s absolute value.

ABS(
<number>
)

## How do you use the ABS function?

The absolute value of a number is a decimal number, whole or decimal, without its symbol. You can use the ABS function as a nested function which requires a positive number as a parameter.

By using the nested ABS function, the numbers returned from the expressions used as parameters can be returned as positive numbers.

## Related Support Forum Posts

Need Help with DAX query using nested IF statement/Switch
Problem With SUMX With IF
Median Of A Time Column

## Considerations when using the ABS function

If you want the absolute value of a number with the same type of data and without its sign, you use the ABS function.

This will ensure that only non-negative numbers are returned from expressions that are nested in functions that require a positive number.

## Formula examples using the ABS function

=ABS (
[DealerPrice]- [ListPrice]
)

= ABS (
SUM ( Table [Amount] )
)

= SUMX (Table,
ABS (
SUM ( Table, [Amount] )
)
)