Comment on page
Table.MatchesAnyRows
Indicates whether any the rows in the table meet the given condition.
function (table
as table,condition
as function) as logical
Indicates whether any the rows in the
table
match the given condition
. Returns true
if any of the rows match, false
otherwise.Table.Row operations
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
Last modified 5yr ago