min() (aggregation function)
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Finds the minimum value of the expression in the table.
Note
This function is used in conjunction with the summarize operator.
Syntax
min (expr)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| expr | string |
✔️ | The expression for which the minimum value is determined. |
Returns
Returns the minimum value of expr across the table.
Tip
This gives you the min on its own. If you want to see other columns in addition to the min, use arg_min.
Example
This example returns the first record in a table.
StormEvents
| summarize FirstEvent=min(StartTime)
Output
| FirstEvent |
|---|
| 2007-01-01T00:00:00Z |