Table.RemoveMatchingRows Function in Power Query
The Table.RemoveMatchingRows function 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.
Syntax
Table.RemoveMatchingRows(table as table, rows as list, optional equationCriteria as any) as table
Example:
Power Query M
let
MyTable = Table.FromRecords(
{
[CustomerID = 1, Name = "Ashish", Phone = "123-4567"],
[CustomerID = 2, Name = "Katrina", Phone = "987-6543"],
[CustomerID = 3, Name = "Alia", Phone = "543-7890"],
[CustomerID = 4, Name = "Vicky", Phone = "676-8479"],
[CustomerID = 5, Name = "Mohini", Phone = "574-8864"],
[CustomerID = 6, Name = "Meenakshi", Phone = "574-8864"],
[CustomerID = 7, Name = "Esha", Phone = "574-8864"],
[CustomerID = 8, Name = "Anjali", Phone = "574-8864"]
}
),
Return = Table.RemoveMatchingRows(MyTable, {[Name="Ashish"]}, "Name")
in
Return The output of the above code is shown in the image below:
