Number.IsOdd

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

Syntax

Number.IsOdd( number as number ) as logical

Description

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

Examples

Check if 625 is an odd number.

// Output: true
Number.IsOdd( 625 )

Check if 82 is an odd number.

// Output: false
Number.IsOdd( 82 )

Related functions

Other functions related to Number.IsOdd are:

• Number.IsEven
• Number.IsNaN

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/number-isodd