ROUNDDOWN DAX Function (Math and Trig)
Rounds a number down, toward zero.
Syntax
ROUNDDOWN ( <Number>, <NumberOfDigits> )
| 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 or omitted, to the nearest integer. |
Return values
Scalar A single decimal value.
The rounded number.
Remarks
If NumberOfDigits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
If NumberOfDigits is 0, the number is rounded to the nearest integer.
If NumberOfDigits is less than 0, the number is rounded to the left of the decimal point.
Related functions
Other related functions are:
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/rounddown-function-dax