Table of contents
TOC
Collapse the table of content
Expand the table of content

List.MaxN

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns the maximum values in the list. After the rows are sorted, optional parameters may be specified to further filter the result

List.MaxN(list as list, countOrCondition as any,  optional comparisonCriteria as any, optional includeNulls as nullable logical) as list  

Arguments

ArgumentDescription
listThe List to check.
countOrConditionSpecifies the number of values to return or a filtering condition.
optional comparisonCriteriaSpecifies how to compare values in the list.
optional includeNullsThe Logical value whether or not to include null values in the return list.

Example

List.MaxN({3, 4, 5, -1, 7, 8, 2}, 5) equals {8, 7, 5, 4, 3}  
© 2018 Microsoft