Filter table by values not contained in a list

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.

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"

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

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

Using the List.Difference(CurrentHistory,ListaDistintos) function probably solves your problem.
If you don't know how to adapt it to your case, publish a table with your data (even fake ones) and explain in detail what you want to achieve

let
    ListaDistintos = {202204, 202201, 20211},
    CurrentHistory ={202204, 202203, 202202, 202201, 202112, 20211},
    History=List.Difference(CurrentHistory,ListaDistintos)
in
    History