Redigera

Dela via

isnan()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Returns whether the input is a Not-a-Number (NaN) value.

Syntax

isnan(number)

Learn more about syntax conventions.

Parameters

Name Type Required Description
number scalar ✔️ The value to check if NaN.

Returns

true if x is NaN and false otherwise.

Example

Run the query

range x from -1 to 1 step 1
| extend y = (-1*x) 
| extend div = 1.0*x/y
| extend isnan=isnan(div)

Output

x y div isnan
-1 1 -1 false
0 0 NaN true
1 -1 -1 false

Related content

  • To check if a value is null, see isnull().
  • To check if a value is finite, see isfinite().
  • To check if a value is infinite, see isinf().