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