ROUNDDOWN function



Description

Rounds a number down, toward zero.

Syntax

ROUNDDOWN (<number>, <num_digits>) 

Parameters

Sr.No. Parameter & Description
1

number

A real number that you want rounded down.

2

num_digits

The number of digits to which you want to round.

Return Value

A decimal number.

Remarks

  • Positive − Number is rounded down to the specified number of decimal places.

  • Zero − Number is rounded to the nearest integer.

  • Negative − Number is rounded to the left of the decimal point.

You can also use the following DAX functions −

  • DAX ROUND function to round to the specified number of digits.

  • DAX ROUNDUP function to always round up (away from zero).

  • DAX MROUND function to round a number to a specific multiple.

  • DAX TRUNC and INT functions to obtain the integer portion of the number.

Example

= ROUNDDOWN (5.55555,2) returns 5.55. 
= ROUNDDOWN (5.55555,0) returns 5. 
= ROUNDDOWN (5.55555, -1) returns 0. 
= ROUNDDOWN (5.55555, -2) returns 0. 
dax_functions_mathematical_trigonometric.htm
Advertisements