Comment on page
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 5yr ago