ROUNDDOWN - Daxplained

ROUNDDOWN is a DAX function that rounds a number down toward zero to the nearest integer or specified significance.

Syntax

ROUNDDOWN(
   Number,
   NumberOfDigits
)

Argument	Properties	Description
Number		Any real number that you want rounded down.
NumberOfDigits		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.
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)

Other functions related to ROUNDDOWN are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/rounddown-function-dax