Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
List.Accumulate
List.AllTrue
List.Alternate
List.AnyTrue
List.Average
List.Buffer
List.Combine
List.Contains
List.ContainsAll
List.ContainsAny
List.Count
List.Covariance
List.Dates
List.DateTimes
List.DateTimeZones
List.Difference
List.Distinct
List.Durations
List.FindText
List.First
List.FirstN
List.Generate
List.InsertRange
List.Intersect
List.IsDistinct
List.IsEmpty
List.Last
List.LastN
List.MatchesAll
List.MatchesAny
List.Max
List.MaxN
List.Median
List.Min
List.MinN
List.Mode
List.Modes
List.NonNullCount
List.Numbers
List.PositionOf
List.PositionOfAny
List.Positions
List.Product
List.Random
List.Range
List.RemoveFirstN
List.RemoveItems
List.RemoveLastN
List.RemoveMatchingItems
List.RemoveNulls
List.RemoveRange
List.Repeat
List.ReplaceMatchingItems
List.ReplaceRange
List.ReplaceValue
List.Reverse
List.Select
List.Single
List.SingleOrDefault
List.Skip
List.Sort
List.Split
List.StandardDeviation
List.Sum
List.Times
List.Transform
List.TransformMany
List.Union
List.Zip
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
List.MinN

List.MinN

Returns the minimum value(s) in the list. The number of values to return or filtering condition may 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 minimum value(s) in the list, list. The 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

Examples

Find the 5 smallest values in the list {3, 4, 5, -1, 7, 8, 2}.
1
List.MinN({3, 4, 5, -1, 7, 8, 2}, 5)
Copied!
{-1, 2, 3, 4, 5}
Previous
List.Min
Next
List.Mode
Last modified 3yr ago
Copy link
Contents
List.MinN
Description
Category
Examples