Forum Discussion
Filter table by values not contained in a list
Hi! I have the following script in M : let Source = Sql.Database("17x.Xx.xx.x", "XXX", [Query = "SELECT TOP 100#(lf)YEARWEEK_DATE,#(lf)YEARMONTH_DATE,#(lf)CONVERT(date, CONVERT(varchar(8), (year...
Add a step in Power Query with Table.SelectRows using List.Contains passing the list and column names as parameters.
List.Contains returns true if the item is in the list so you want to put a "not" in front of it.
Let me know if that is enough to help you.
Hi HotChilli ...but list contains is used to find a value, not different values...shouldn't be, list.containsany? I don´t know how final filteredHistory line would be....