Number.IsEven
true when a number is even: divisible by 2 once its fraction is dropped.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.IsEven(number as number) as logical| Parameter | Type | Description |
|---|---|---|
number | number | The number to test. |
Returns
logical. true for an even number, false otherwise.
Remarks
- A fraction is dropped first, so 2.5 counts as 2 and is even, as in Power Query. For a negative number the whole number at or below counts: -2.5 is taken as -3, odd.
- null is an error: the parameter is a number, not a nullable one.
Examples
An even number
Number.IsEven(4)trueThe even rows of a list
List.Select({1, 2, 3, 4, 5, 6}, Number.IsEven){2, 4, 6}A fraction
Number.IsEven(2.5)true