Power Fx function
Abs — Power Fx function reference
Absolute value.
Syntax
powerfx
Abs( Number )
Examples
powerfx
Abs(-8)
→ 8
powerfx
Abs(DateDiff(DueDate, Today(), TimeUnit.Days))
powerfx
Abs(actual - budget)
Common mistakes & gotchas
- Abs(Blank()) returns 0, not blank or an error, since blank coerces to 0 in numeric context.
- Frequently paired with DateDiff to express "days overdue/early" as a positive magnitude — combine with Sign() if the direction also matters.
Related Power Fx functions
From Math & aggregation