List.Max
List.Max(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as any
Returns the maximum item in the list list
, or the optional default value default
if the list is empty. An optional comparisonCriteria value, comparisonCriteria
, may be specified to determine how to compare the items in the list. If this parameter is null, the default comparer is used.
Find the max in the list {1, 4, 7, 3, -2, 5}.
Usage
List.Max({1, 4, 7, 3, -2, 5}, 1)
Output
7
Find the max in the list {} or return -1 if it is empty.
Usage
List.Max({}, -1)
Output
-1