Number.Mod
What is left over when one number is divided by another a whole number of times.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.Mod(number as nullable number, divisor as nullable number, optional precision as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
number | nullable number | The number to divide. |
divisor | nullable number | The number to divide by. |
precision | nullable number optional | Precision.Double (the default) or Precision.Decimal. |
Returns
nullable number. The remainder, with the sign of the number divided; null when either number is null.
Remarks
- The remainder takes the sign of the first number: -7 mod 2 is -1, not 1.
- Fractions work too: 7.5 mod 2 is 1.5.
Examples
Items left after filling boxes of 12
Number.Mod(125, 12)5A negative number
Number.Mod(-7, 2)-1Every third order
List.Select({1001, 1002, 1003, 1004, 1005, 1006}, each Number.Mod(_, 3) = 0){1002, 1005}