isnan()

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft 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

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
  • 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().