Cheat Sheets/Power BI/ROUNDUP / ROUNDDOWN
DAX function

ROUNDUP / ROUNDDOWNDAX function reference

Round away from / toward zero.

Syntax

dax
ROUNDUP(<number>, <num_digits>)    ROUNDDOWN(<number>, <num_digits>)

Examples

dax
ROUNDUP([Sales], 0)
A number
dax
ROUNDUP(DIVIDE(COUNTROWS(Sales), 50), 0)
Number of pages needed at 50 rows per page, always rounding up
dax
ROUNDDOWN([Discount %] * 100, 0) / 100
Truncates a discount percentage to a whole percent, never rounding up

Common mistakes & gotchas

Related DAX functions

From Math & statistics

Used in these tutorials

← Back to the Power BI (DAX) cheat sheet