ROUNDDOWN Function (DAX)
How does the ROUNDDOWN function (DAX) work?
The ROUNDDOWN function (DAX) rounds a number down, toward zero.
ROUNDDOWN Formula Syntax
ROUNDDOWN(
<number>, <num_digits>
)
How do you use the ROUNDDOWN function?
The ROUNDDOWN function will always round numbers down. The number of places to round to is controlled by the num_digits argument. Positive numbers round to the right of the decimal point, negative numbers round to the left, and zero rounds to the nearest 1.
Related Blog Posts
Related Support Forum Posts
Iterating a distinctcount between two tables
Grouping customers evenly by rank
Dax Calculation question
Considerations when using the ROUNDDOWN function
If num_digits is greater than 0 (zero), then the value in number is rounded down to the specified number of decimal places.
If num_digits is 0, then the value in number is rounded down to the nearest integer.
If num_digits is less than 0, then the value in number is rounded down to the left of the decimal point.
Related Video Tutorials
Formula examples using the ROUNDDOWN function
=ROUNDDOWN(3.14159,3)
=ROUNDDOWN(31415.92654, -2)
=ROUNDDOWN(76.9,0)
Related DAX Functions
Related Course Modules
DOWNLOAD
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.
