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...
I agree with not List.Contains(NameOfListWithValuesToExclude, [ColumnToFilter])
Which is to say, return the rows that do not contain these values in this column.
Also, be sure to
List.Buffer(List.Distinct(
so that your query is nice and fast and folding.
--Nate
--Nate