Updated on

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

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


Number.IsOdd( number as number ) as logical


Indicates if the value is odd. Returns true if number is an odd number, false otherwise.


Check if 625 is an odd number.

// Output: true
Number.IsOdd( 625 )

Check if 82 is an odd number.

// Output: false
Number.IsOdd( 82 )

Other functions related to Number.IsOdd are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: