Table.Max

Table.Max
Returns the largest row or default value using the given criteria.
function (table as table, optional comparisonCriteria as nullable any, optional default as nullable any) as nullable any
Description
Returns the largest row in the table, given the comparisonCriteria. If the table is empty, the optional default value is returned.
Category
Table.Ordering
Examples
Find the row with the largest value in column [a] in the table ({[a = 2, b = 4], [a = 6, b = 8]}).
Table.Max(Table.FromRecords({[a = 2, b = 4], [a = 6, b = 8]}), "a")
[a = 6, b = 8]
Find the row with the largest value in column [a] in the table ({}). Return -1 if empty.
Table.Max(#table({"a"},{}), "a", -1)
-1

Table.MatchesAnyRows

Table.MaxN

Last modified 4yr ago