Table.MinN
Table.MinN(table as table, comparisonCriteria as any, countOrCondition as any) as table
Returns the smallest row(s) in the table
, given the comparisonCriteria
. After the rows are sorted, the countOrCondition
parameter must be specified to further filter the result. Note the sorting algorithm cannot guarantee a fixed sorted result. The countOrCondition
parameter can take multiple forms:
- If a number is specified, a list of up to
countOrCondition
items in ascending order is returned. - If a condition is specified, a list of items that initially meet the condition is returned. Once an item fails the condition, no further items are considered.
Find the row with the smallest value in column [a] with the condition [a] < 3, in the table. The rows are sorted before the filter is applied.
Usage
Table.MinN(
Table.FromRecords({
[a = 2, b = 4],
[a = 0, b = 0],
[a = 6, b = 4]
}),
"a",
each [a] < 3
)
Output
Table.FromRecords({
[a = 0, b = 0],
[a = 2, b = 4]
})
Find the row with the smallest value in column [a] with the condition [b] < 0, in the table. The rows are sorted before the filter is applied.
Usage
Table.MinN(
Table.FromRecords({
[a = 2, b = 4],
[a = 8, b = 0],
[a = 6, b = 2]
}),
"a",
each [b] < 0
)
Output
Table.FromRecords({})