Number.RoundTowardZero
Drops the fraction of a number, or the decimals past a place: positive numbers round down, negative ones up.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.RoundTowardZero(number as nullable number, optional digits as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
number | nullable number | The number to work on; null gives null. |
digits | nullable number optional | How many decimal places to keep; 0, a whole number, when left out. |
Returns
nullable number. The number cut toward zero, keeping its sign; null for null.
Examples
A positive number
Number.RoundTowardZero(12.7)12A negative number
Number.RoundTowardZero(-12.7)-12The fraction is cut off, so -12.7 becomes -12, not -13.
Two decimal places
Number.RoundTowardZero(-1.234, 2)-1.23Related functions
Number.RoundAwayFromZero, Number.RoundDown, Number.IntegerDivide, Number.Round.