DAX Math & Trigonometric MROUND function


Advertisements

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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements