Number.Round(number as nullable number, optional digits as nullable number, optional roundingMode as nullable number) as nullable number


Returns the result of rounding number to the nearest number. If number is null, Number.Round returns null. number is rounded to the nearest integer, unless the optional parameter digits is specified. If digits is specified, number is rounded to the digits number of decimal digits. An optional roundingMode parameter specifies rounding direction when there is a tie between the possible numbers to round to (see RoundingMode.Type for possible values).

Reference Data

Power Query M Functions / Number Functions / Number.Round