List.RemoveMatchingItems

Syntax

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

Description

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

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / List Functions / List.RemoveMatchingItems