Power Fx function
RoundUp / RoundDown — Power Fx function reference
Round away from / toward zero.
Syntax
powerfx
RoundUp( Number, NumDecimalPlaces ) / RoundDown( Number, NumDecimalPlaces )
Examples
powerfx
RoundUp(12.31, 1)
→ 12.4
Pages needed at 10 items per page.
powerfx
RoundUp(CountRows(colCart) / 10, 0)
powerfx
RoundDown(Amount, 0)
Common mistakes & gotchas
- RoundUp always moves away from zero and RoundDown always moves toward zero regardless of sign — RoundUp(-1.2, 0) = -2, not -1, which surprises people expecting "ceiling" behavior for negatives.
- RoundUp(x / pageSize, 0) is the standard total-pages pattern; RoundDown would under-count a partial last page.
Related Power Fx functions
From Math & aggregation