Number.RoundDown Function of Power Query
The Number.RoundDown function returns the largest integer less than or equal to a number value.
Syntax
Number.RoundDown(number as nullable number, optional digits as nullable number) as nullable number
Example:
Power Query M
let
MyTable = Table.FromRecords(
{
[CustomerID = 1, Name = "Ashish", Marks = 56.8],
[CustomerID = 2, Name = "Katrina", Marks = 65.5],
[CustomerID = 3, Name = "Alia", Marks = 38.1],
[CustomerID = 4, Name = "Vicky", Marks = 45.8],
[CustomerID = 5, Name = "Mohini", Marks = 27.8],
[CustomerID = 6, Name = "Meenakshi", Marks = 28.9],
[CustomerID = 7, Name = "Esha", Marks = 67.5],
[CustomerID = 8, Name = "Anjali", Marks = 38.2]
}
),
return = Table.AddColumn(MyTable, "RoundedDown", (_) => Number.RoundDown(_[Marks]))
in
return
The output of the above code is shown below:
