Number.RoundDown is a Power Query M function that rounds a given number down to the previous highest integer, with support for optional digits parameter. The function returns the rounded number or null if the input is null.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


   number as nullable number,
   optional digits as nullable number,
) as nullable number


Returns the result of rounding number down to the previous highest integer. If number is null, this function returns null. If digits is provided, number is rounded to the specified number of decimal digits.


Round down 1.234 to integer.

// Output: 1
Number.RoundDown( 1.234 )

Round down 1.999 to integer.

// Output: 1
Number.RoundDown( 1.999 )

Round down 1.999 to two decimal places.

// Output: 1.99
Number.RoundDown( 1.999, 2 )

Other functions related to Number.RoundDown are:

BI Gorilla Blog

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.