Number.RoundDown

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

Syntax

Number.RoundDown(
   number as nullable number,
   optional digits as nullable number,
) as nullable number

Description

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.

Examples

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 )

Related functions

Other functions related to Number.RoundDown are:

• Number.Round
• Number.RoundAwayFromZero
• Number.RoundTowardZero
• Number.RoundUp

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