Power Query
published
Search
K
Comment on page

Table.RemoveMatchingRows

Table.RemoveMatchingRows

Removes all occurrences of the specified rows from the table.
function (table as table, rows as list, optional equationCriteria as nullable any) as table

Description

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.

Category

Table.Membership

Examples

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" })