Number.IsEven

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

Syntax

Number.IsEven( number as number ) as logical

Description

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

Examples

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: https://learn.microsoft.com/en-us/powerquery-m/number-iseven