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

Table.RemoveLastN

Table.RemoveRows

Last modified 4yr ago