RoundingMode.Type

Updated on

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:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/roundingmode-type