List.MinN

This function will return the minimum value or values in a given list. The parameter 'countOrCondition' can be used to specify either the number of values to return or a filtering condition. If a number is provided, the function will return a list of up to that many items in ascending order. If a condition is specified, the function will return a list of items that initially meet the condition, stopping once an item fails the condition. If 'countOrCondition' is null, the function will simply return the single smallest value in the list. Optionally, a 'comparisonCriteria' parameter can be included to define how values in the list should be compared. If 'comparisonCriteria' is left null, the default comparer will be used.

Locate the five smallest values in the array {3, 4, 5, -1, 7, 8, 2} using the Power Query MList.MinN function. The function MList.MinN({3, 4, 5, -1, 7, 8, 2}, 5) will return the output {-1, 2, 3, 4, 5}.