max_of()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Returns the maximum value of all argument expressions.
max_of(
arg,
arg_2,
[ arg_3,
... ])
Learn more about syntax conventions.
Name | Type | Required | Description |
---|---|---|---|
arg_i | scalar | ✔️ | The values to compare. |
- All arguments must be of the same type.
- Maximum of 64 arguments is supported.
- Non-null values take precedence to null values.
The maximum value of all argument expressions.
print result = max_of(10, 1, -3, 17)
Output
result |
---|
17 |
Notice that non-null values take precedence over null values.
datatable (A: int, B: int)
[
1, 6,
8, 1,
int(null), 2,
1, int(null),
int(null), int(null)
]
| project max_of(A, B)
Output
result |
---|
6 |
8 |
2 |
1 |
(null) |