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...
You could also just turn your list into a table and use an Left or Right Anti join (depending on which is your left vs right table).
--Nate