ABS is a DAX function that returns the absolute value of a number.
Syntax
ABS( Number )| Argument | Properties | Description |
|---|---|---|
| Number | The number for which you want the absolute value. |
ABS
Updated on
ABS is a DAX function that returns the absolute value of a number.
ABS( Number )| Argument | Properties | Description |
|---|---|---|
| Number | The number for which you want the absolute value. |
A decimal number.
The absolute value of a number is a decimal number, whole or decimal, without its sign. You can use the ABS function to ensure that only non-negative numbers are returned from expressions when nested in functions that require a positive number.
The following example returns the absolute value of the difference between the list price and the dealer price, which you might use in a new calculated column, DealerMarkup.
= ABS([DealerPrice]-[ListPrice])
Other functions related to ABS are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy