Number.IsNaN

Number.IsNaN is a Power Query M function that checks if a given value is NaN (Not a Number). The function returns true if the input number is equivalent to NaN, and false otherwise.

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

Syntax

Number.IsNaN( number as number ) as logical

Description

Indicates if the value is NaN (Not a number). Returns true if number is equivalent to Number.IsNaN, false otherwise.

Examples

Check if 0 divided by 0 is NaN.

// Output: true
Number.IsNaN( 0/0 )

Check if 1 divided by 0 is NaN.

// Output: false
Number.IsNaN( 1/0 )

Related functions

Other functions related to Number.IsNaN are:

• Number.IsEven
• Number.IsOdd

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