Number.RoundDown
This function calculates the rounded down integer of a given number. If the number provided is null, the function will return null. If a specific number of decimal digits are specified, the function w...
Number.RoundDown(number as nullable number, optional digits as nullable number) as nullable numberThis function calculates the rounded down integer of a given number. If the number provided is null, the function will return null. If a specific number of decimal digits are specified, the function will round the number to that decimal precision.
Example 1
Reduce the number 1.234 to the nearest whole number.
Usage:
In Power Query M, use the function MNumber.RoundDown(1.234).
Output:
1
Example 2
Round down the number 1.999 to the nearest whole number.
Usage:
In Power Query M, use the function MNumber.RoundDown(1.999).
Output:
1
Example 3
Round down the number 1.999 to two decimal places.
Usage:
In Power Query M, use the function MNumber.RoundDown(1.999, 2).
Output:
1.99