Cheat Sheets/Power BI/ABS
DAX function

ABSDAX function reference

Absolute value.

Syntax

dax
ABS(<number>)

Examples

dax
ABS([Variance])
A number
dax
RANKX(ALL(Product), ABS([Budget Variance]))
Ranks products by the size of their variance regardless of over/under direction
dax
IF(ABS([Actual] - [Budget]) > [Budget] * 0.1, "Out of tolerance", "OK")
Flags variances beyond 10% in either direction

Common mistakes & gotchas

Related DAX functions

From Math & statistics

← Back to the Power BI (DAX) cheat sheet