List.Min
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Returns the minimum item in a list, or the optional default value if the list is empty.
List.Min(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as any
| Argument | Description |
|---|---|
| list | The List to check. |
| optional default | The default value to return. |
| optional comparisonCriteria | Specifies how to compare values in the list. If this argument is null, the default comparer is used. |
| optional includeNulls | The Logical value whether or not to include null values in the return list. |
List.Min({1, 4, 7, 3, -2, 5}) equals -2
Show: