Table.Min
Returns the smallest row or a default value using the given criteria.
function (table
as table, optionalcomparisonCriteria
as nullable any, optionaldefault
as nullable any) as nullable any
Returns the smallest 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 smallest value in column [a] in the table.
Table.Min(Table.FromRecords({[a = 2, b = 4], [a = 6, b = 8]}), "a")
[a = 2, b = 4]
Find the row with the smallest value in column [a] in the table. Return -1 if empty.
Table.Min(#table({"a"},{}), "a", -1)
-1
Last modified 4yr ago