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.

Scalar A single decimal value.

The rounded number.

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.

Other related functions are:

Contributors: Alberto Ferrari, Marco Russo