DAX Math & Trigonometric MROUND function



Description

Returns a number rounded to the desired multiple.

Syntax

MROUND (<number>, <multiple>)

Parameters

Sr.No. Parameter & Description
1

number

The number to round.

2

multiple

The multiple of significance to which you want to round the number.

Return Value

A decimal number.

Remarks

MROUND rounds up, away from zero, if the remainder of the dividing number by the specified multiple is greater than or equal to half the value of multiple.

If the number and multiple are not of the same sign, the function returns an error.

Example

= MROUND (8.2,3) returns 9. 
= MROUND (-8.2, -3) returns -9. 
dax_functions_mathematical_trigonometric.htm
Advertisements