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:

BI Gorilla Youtube Channel

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.