- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
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