ROUNDDOWN DAX Function (Math and Trig)
Rounds a number down, toward zero.
Syntax
| Parameter | Attributes | 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. |
Return values
The rounded number.
Remarks
If NumberOfDigits is greater than 0 (zero), then number is rounded down to the specified number of decimal places.
If NumberOfDigits is 0, the number is rounded down to the nearest integer.
If NumberOfDigits is less than 0, the number is rounded down to the left of the decimal point.
Examples
-- Argument for rounding functions:
-- positive: at a given number of decimal places
-- zero: to the nearest integer
-- negative: rounds digits to the left of the decimal point
--
-- ROUND rounds to the nearest value
-- ROUNDDOWN always rounds down
-- ROUNDUP always rounds up
-- TRUNC truncates the decimal part, returning an integer
DEFINE
VAR Vals = GENERATESERIES ( 14.90, 16.01, 0.03 )
EVALUATE
ADDCOLUMNS (
Vals,
"ROUND +1", ROUND ( [Value], 1 ),
"ROUND -1", ROUND ( [Value], -1 ),
"ROUNDDOWN +1", ROUNDDOWN ( [Value], 1 ),
"ROUNDDOWN -1", ROUNDDOWN ( [Value], -1 ),
"ROUNDUP +1", ROUNDUP ( [Value], 1 ),
"ROUNDUP -1", ROUNDUP ( [Value], -1 ),
"TRUNC", TRUNC ( [Value] )
)
ORDER BY [Value] ASC
| Value | ROUND +1 | ROUND -1 | ROUNDDOWN +1 | ROUNDDOWN -1 | ROUNDUP +1 | ROUNDUP -1 | TRUNC |
|---|---|---|---|---|---|---|---|
| 14.90 | 14.90 | 10 | 14.90 | 10 | 14.90 | 20 | 14 |
| 14.93 | 14.90 | 10 | 14.90 | 10 | 15.00 | 20 | 14 |
| 14.96 | 15.00 | 10 | 14.90 | 10 | 15.00 | 20 | 14 |
| 14.99 | 15.00 | 10 | 14.90 | 10 | 15.00 | 20 | 14 |
| 15.02 | 15.00 | 20 | 15.00 | 10 | 15.10 | 20 | 15 |
| 15.05 | 15.10 | 20 | 15.00 | 10 | 15.10 | 20 | 15 |
| 15.08 | 15.10 | 20 | 15.00 | 10 | 15.10 | 20 | 15 |
| 15.11 | 15.10 | 20 | 15.10 | 10 | 15.20 | 20 | 15 |
| 15.14 | 15.10 | 20 | 15.10 | 10 | 15.20 | 20 | 15 |
| 15.17 | 15.20 | 20 | 15.10 | 10 | 15.20 | 20 | 15 |
| 15.20 | 15.20 | 20 | 15.20 | 10 | 15.20 | 20 | 15 |
| 15.23 | 15.20 | 20 | 15.20 | 10 | 15.30 | 20 | 15 |
| 15.26 | 15.30 | 20 | 15.20 | 10 | 15.30 | 20 | 15 |
| 15.29 | 15.30 | 20 | 15.20 | 10 | 15.30 | 20 | 15 |
| 15.32 | 15.30 | 20 | 15.30 | 10 | 15.40 | 20 | 15 |
| 15.35 | 15.40 | 20 | 15.30 | 10 | 15.40 | 20 | 15 |
| 15.38 | 15.40 | 20 | 15.30 | 10 | 15.40 | 20 | 15 |
| 15.41 | 15.40 | 20 | 15.40 | 10 | 15.50 | 20 | 15 |
| 15.44 | 15.40 | 20 | 15.40 | 10 | 15.50 | 20 | 15 |
| 15.47 | 15.50 | 20 | 15.40 | 10 | 15.50 | 20 | 15 |
| 15.50 | 15.50 | 20 | 15.50 | 10 | 15.50 | 20 | 15 |
| 15.53 | 15.50 | 20 | 15.50 | 10 | 15.60 | 20 | 15 |
| 15.56 | 15.60 | 20 | 15.50 | 10 | 15.60 | 20 | 15 |
| 15.59 | 15.60 | 20 | 15.50 | 10 | 15.60 | 20 | 15 |
| 15.62 | 15.60 | 20 | 15.60 | 10 | 15.70 | 20 | 15 |
| 15.65 | 15.70 | 20 | 15.60 | 10 | 15.70 | 20 | 15 |
| 15.68 | 15.70 | 20 | 15.60 | 10 | 15.70 | 20 | 15 |
| 15.71 | 15.70 | 20 | 15.70 | 10 | 15.80 | 20 | 15 |
| 15.74 | 15.70 | 20 | 15.70 | 10 | 15.80 | 20 | 15 |
| 15.77 | 15.80 | 20 | 15.70 | 10 | 15.80 | 20 | 15 |
| 15.80 | 15.80 | 20 | 15.80 | 10 | 15.80 | 20 | 15 |
| 15.83 | 15.80 | 20 | 15.80 | 10 | 15.90 | 20 | 15 |
| 15.86 | 15.90 | 20 | 15.80 | 10 | 15.90 | 20 | 15 |
| 15.89 | 15.90 | 20 | 15.80 | 10 | 15.90 | 20 | 15 |
| 15.92 | 15.90 | 20 | 15.90 | 10 | 16.00 | 20 | 15 |
| 15.95 | 16.00 | 20 | 15.90 | 10 | 16.00 | 20 | 15 |
| 15.98 | 16.00 | 20 | 15.90 | 10 | 16.00 | 20 | 15 |
| 16.01 | 16.00 | 20 | 16.00 | 10 | 16.10 | 20 | 16 |
Related functions
Other related functions are:
Last update: May 24, 2022 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/rounddown-function-dax