Export (0) Print
Expand All

ROUNDDOWN Function (DAX)

Rounds a number down, toward zero.


ROUNDDOWN(<number>, <num_digits>)

Term

Definition

number

A real number that you want rounded down.

num_digits

The number of digits to which you want to round. Negative rounds to the left of the decimal point; zero to the nearest integer.

A decimal number.

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 Functions

ROUNDDOWN behaves like ROUND, except that it always rounds a number down. The INT function also rounds down, but with INT the result is always an integer, whereas with ROUNDDOWN you can control the precision of the result.

The following example rounds 3.14159 down to three decimal places. The expected result is 3.141.

=ROUNDDOWN(3.14159,3)

The following example rounds the value of 31415.92654 down to 2 decimal places to the left of the decimal. The expected result is 31400.

=ROUNDDOWN(31415.92654, -2)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft