List.Max

List.Max
Returns the maximum value or the default value for an empty list.
function (list as list, optional default as nullable any, optional comparisonCriteria as nullable any, optional includeNulls as nullable any) as nullable any
Description
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.
Category
List.Ordering
Examples
Find the max in the list {1, 4, 7, 3, -2, 5}.
List.Max({1, 4, 7, 3, -2, 5},1)
7
Find the max in the list {} or return -1 if it is empty.
List.Max({}, -1)
-1

List.MatchesAny

List.MaxN

Last modified 4yr ago