RoundingMode.Type

RoundingMode.Type specifies rounding direction when there is a tie between the possible numbers to round to.

Enumeration Options

Enumerations simplify the process of selecting options within a function. To specify the RoundingMode.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).

ArgumentValueDescription
RoundingMode.Up0Round up when there is a tie between the possible numbers to round to.
RoundingMode.Down1Round down when there is a tie between the possible numbers to round to.
RoundingMode.AwayFromZero2Round away from zero when there is a tie between the possible numbers to round to.
RoundingMode.TowardZero3Round toward zero when there is a tie between the possible numbers to round to.
RoundingMode.ToEven4Round to the nearest even number when there is a tie between the possible numbers to round to.

Applies to

Here’s a list of functions that work with RoundingMode.Type:

BI Gorilla Blog

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/roundingmode-type
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.