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