Number.Mod
NumberReturns the remainder from dividing a number by a divisor.
Syntax
Number.Mod(number as nullable number, divisor as nullable number) as nullable numberParameters
| Name | Type | Required | Description |
|---|---|---|---|
number | number | Yes | The dividend. |
divisor | number | Yes | The divisor. |
Return Value
number — The remainder after integer division.
Remarks
Number.Mod returns the remainder of the division of number by divisor. This is equivalent to the mathematical modulo operation. A common use is classifying rows as odd or even based on an ID column, or cycling through groups for round-robin assignment.
If divisor is zero, an error is raised.
Examples
Example 1: Flag odd and even OrderIDs
Table.AddColumn(
Table.SelectColumns(Table.FirstN(Sales, 6), {"OrderID", "Product"}),
"OddEven", each if Number.Mod([OrderID], 2) = 0 then "Even" else "Odd", type text
)Result
OrderID | Product | OddEven | |
|---|---|---|---|
| 1 | 1 | Widget A | Odd |
| 2 | 2 | Gadget B | Even |
| 3 | 3 | Widget C | Odd |
| 4 | 4 | Gadget D | Even |
| 5 | 5 | Widget A | Odd |
| 6 | 6 | Thingamajig E | Even |
Compatibility
✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks