Power Query
published
Search
⌃K

List.MaxN

List.MaxN

Returns the maximum value(s) in the list. The number of values to return or filtering condition must be specified.
function (list as list, optional countOrCondition as nullable any, optional comparisonCriteria as nullable any, optional includeNulls as nullable any) as list

Description

Returns the maximum value(s) in the list, list. After the rows are sorted, optional parameters may be specified to further filter the result. The optional parameter, countOrCondition, specifies the number of values to return or a filtering condition. The optional parameter, comparisonCriteria, specifies how to compare values in the list.
comparisonCriteria: [Opional] An optional comparisonCriteria value, 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
Last modified 4yr ago