Comment on page

Table.MaxN

Table.MaxN
Returns the largest row(s) using the given criteria.
function (table as table, optional comparisonCriteria as nullable any, optional countOrCondition as nullable any) as table
Description
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:   
Category
Table.Ordering
Examples
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({})

Table.Max

Table.Min

Last modified 5yr ago