Table.MaxN
Returns the largest row(s) using the given criteria.
function (table
as table, optionalcomparisonCriteria
as nullable any, optionalcountOrCondition
as nullable any) as table
Returns the largest 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: Table.Ordering
Find the row with the largest value in column [a] with the condition [a] > 0, in the table. The rows are sorted before the filter is applied.
Table.MaxN(Table.FromRecords({[a = 2, b = 4], [a = 0, b = 0], [a = 6, b = 2]}), "a", each [a] > 0)
Table.FromRecords({[a = 6, b = 2], [a = 2, b = 4]})
Find the row with the largest value in column [a] with the condition [b] > 0, in the table. The rows are sorted before the filter is applied.
Table.MaxN(Table.FromRecords({[a = 2, b = 4], [a = 8, b = 0], [a = 6, b = 2]}), "a", each [b] > 0)
Table.FromRecords({})
Last modified 4yr ago