List.RemoveItems Function in Power Query
The List.RemoveItems function removes all occurrences of the given values in the list2 from list1. If the values in list2 don't exist in list1, the original list is returned.
Syntax
List.RemoveItems(list1 as list, list2 as list) as list
Example:
Power Query M
let
Source = {"India", "America", "Canada", "Japan", "Australia", "England"},
RemoveItemsinList = List.RemoveItems(Source, {"Canada", "Japan"})
in
RemoveItemsinList The output will be shown in the following image:
