List.Max
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 maximum item in a list, or the optional default value if the list is empty.
List.Max(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 | An optional comparison criteria value to control equality testing. 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.Max({1, 4, 7, 3, -2, 5}, 1) equals 7
Show: