Table.RemoveMatchingRows
Removes all occurrences of the specified rows from the table.
function (table
as table,rows
as list, optionalequationCriteria
as nullable any) as table
Removes all occurrences of the specified
rows
from the table
. An optional parameter equationCriteria
may be specified to control the comparison between the rows of the table.Table.Membership
Remove any rows where [a = 1] from the table
({[a = 1, b = 2], [a = 3, b = 4], [a = 1, b = 6]})
.Table.RemoveMatchingRows(Table.FromRecords({[a = 1, b = 2], [a = 3, b = 4], [a = 1, b = 6]}), {[a = 1]}, "a")
Table.FromRecords({[a = 3, b = 4]}, { "a", "b" })
Last modified 4yr ago