Number.IsEven
NumberReturns true if a number is even.
Syntax
Number.IsEven(number as number) as logicalParameters
| Name | Type | Required | Description |
|---|---|---|---|
number | number | Yes | The number to check. |
Return Value
logical — true if the number is even; false otherwise.
Remarks
Number.IsEven returns true when a number is divisible by 2 with no remainder, and false otherwise. This is a shorthand for Number.Mod(number, 2) = 0.
A practical use case is applying alternating row styling logic, filtering even-numbered records, or splitting data into two groups based on ID parity.
Examples
Example 1: Check which OrderIDs are even
Table.AddColumn(
Table.SelectColumns(Table.FirstN(Sales, 6), {"OrderID", "Product"}),
"IsEven", each Number.IsEven([OrderID]), type logical
)Result
OrderID | Product | IsEven | |
|---|---|---|---|
| 1 | 1 | Widget A | FALSE |
| 2 | 2 | Gadget B | TRUE |
| 3 | 3 | Widget C | FALSE |
| 4 | 4 | Gadget D | TRUE |
| 5 | 5 | Widget A | FALSE |
| 6 | 6 | Thingamajig E | TRUE |
Compatibility
✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks