你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
isfinite()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft 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 |