List.RemoveItems

 

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 items from list1 that are present in list2, and returns a new list.

List.RemoveItems(list1 as list, list2 as list) as list  

ArgumentDescription
list1The List to modify.
list2The list of items to remove.
List.RemoveItems({1, 2, 3, 3}, {3}) equals { 1, 2}  

Show: