Table.Max
Returns the largest row or default value using the given criteria.
function (table
as table, optionalcomparisonCriteria
as nullable any, optionaldefault
as nullable any) as nullable any
Returns the largest row in the
table
, given the comparisonCriteria
. If the table is empty, the optional default
value is returned.Table.Ordering
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
Last modified 4yr ago