Table.MatchesAnyRows

Table.MatchesAnyRows
Indicates whether any the rows in the table meet the given condition.
function (table as table, condition as function) as logical
Description
Indicates whether any the rows in the table match the given condition. Returns true if any of the rows match, false otherwise.
Category
Table.Row operations
Examples
Determine whether any of the row values in column [a] are even in the table ({[a = 2, b = 4], [a = 6, b = 8]}).
Table.MatchesAnyRows(Table.FromRecords({[a = 1, b = 4], [a = 3, b = 8]}), each Number.Mod([a], 2) = 0 )
false
Determine whether any of the row values are [a = 1, b = 2], in the table ({[a = 1, b = 2], [a = 3, b = 4]}).
Table.MatchesAnyRows(Table.FromRecords({[a = 1, b = 2], [a = -3, b = 4]}), each _ = [a = 1, b = 2])
true

Table.MatchesAllRows

Table.Max

Last modified 4yr ago