Updated on

Number.IsEven is a Power Query M function that determines if a given number is even. The function returns true if the input number is even, and false otherwise.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Number.IsEven( number as number ) as logical


Indicates if the value, number, is even by returning true if it is even, false otherwise.


Check if 625 is an even number.

// Output: false
Number.IsEven( 625 )

Check if 82 is an even number.

// Output: true
Number.IsEven( 82 )

Other functions related to Number.IsEven are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: