Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Tips and Tricks
ronrsnfld's avatar
ronrsnfld
Super User
4 years ago

Here is an example of one method:

 

let
   ListaDistintos={202204,202201,202211},
   #"Current History Table" = Table.FromColumns(
       {{202204, 202203, 202202, 202201, 202112, 202211}}, {"Date?"}),
    #"Filtered History" = Table.SelectRows(#"Current History Table", 
            each not List.Contains(ListaDistintos,[#"Date?"]))
in  #"Filtered History"
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,ronrsnfld , I have to use Listcontains() or List.ContainsAny() ?... I´m comparing a list of values, vs lot of values, not only one... ???

 

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    4 years ago

    No. You compare each entry in the column, one at a time, to the contents of your List.  What happened when ran the code I posted?  Here it returned the items you specified in your question.