Table.RemoveMatchingRows

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Removes all occurrences of rows from a table.

Table.RemoveMatchingRows(table as table, rows as list, optional equationCriteria as any) as table  

ArgumentDescription
tableThe Table to modify.
rowsThe List of rows to remove.
optional equationCriteriaAn optional value that specifies how to control comparison between the rows of the table.

Table.RemoveMatchingRows is similar to List.RemoveMatchingItems but requires a table as input.

Table.RemoveMatchingRows(Table.FromRecords(  
  
{  
  
      [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0],  
  
      [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0],  
  
      [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0],  
  
      [OrderID = 4, CustomerID = 3, Item = "Fish tazer", Price = 200.0],  
  
      [OrderID = 5, CustomerID = 3, Item = "Bandaids", Price = 2.0],  
  
      [OrderID = 6, CustomerID = 1, Item = "Tackle box", Price = 20.0],  
  
      [OrderID = 7, CustomerID = 5, Item = "Bait", Price = 3.25],  
  
      [OrderID = 8, CustomerID = 5, Item = "Fishing Rod", Price = 100.0],  
  
      [OrderID = 9, CustomerID = 6, Item = "Bait", Price = 3.25]  
  
}  
  
), {[CustomerID = 3]}, "CustomerID")  

OrderIDCustomerIDItemPrice
11Fishing rod100
211 lb. worms5
32Fishing net25
61Tackle box20
75Bait3.25
85Fishing Rod100
96Bait3.25
Show: