你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn

isfinite()

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft Sentinel

Returns whether the input is a finite value, meaning it's not infinite or NaN.

Syntax

isfinite(number)

Learn more about syntax conventions.

Parameters

Name Type Required Description
number real ✔️ The value to check if finite.

Returns

true if x is finite and false otherwise.

Example

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

Output

x y div isfinite
-1 0 -∞ 0
0 0 NaN 0
1 0 0
  • To check if a value is null, see isnull().
  • To check if a value is infinite, see isinf().
  • To check if a value is NaN (Not-a-Number), see isnan().