Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
Syntax
Table.Min(
table as table,
comparisonCriteria as any,
optional default as any
) as any
About
Returns the smallest row in the table, given the comparisonCriteria. If the table is empty, the optional default value is returned.
Example 1
Find the row with the smallest value in column [a] in the table.
Usage
Table.Min(
Table.FromRecords({
[a = 2, b = 4],
[a = 6, b = 8]
}),
"a"
)
Output
[a = 2, b = 4]
Example 2
Find the row with the smallest value in column [a] in the table. Return -1 if empty.
Usage
Table.Min(#table({"a"}, {}), "a", -1)
Output
-1