List.RemoveMatchingItems(list1 as list, list2 as list, optional equationCriteria as any) as list


Removes all occurrences of the given values in list2 from the list list1. If the values in list2 don’t exist in list1, the original list is returned. An optional equation criteria value, equationCriteria, can be specified to control equality testing.

Reference Data

Power Query M Functions / List Functions / List.RemoveMatchingItems