List.MinN

 

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 minimum values in a list.

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

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.
List.MinN({3, 4, 5, -1, 7, 8, 2}, 5) equals {-1, 2, 3, 4, 5}  

Show: