Power Query filtering many values

[Anonymous]

So I know what with the following script I could remove from "Cost Center" column all the value that are "aaaa", "bbbb" or "cccc" but what about if I had to remove more values like  50 that I already have set in a list in power query o maybe a column from another data set..

I could not find the proper script

Table.SelectRows(#"", each ([Cost Center] <> "aaaa" and [Cost Center] <> "bbbb" and [Cost Center] <> "cccc"))

[AlexisOlson · Accepted solution]

You could use List.Contains.

each not List.Contains(ListOfValues,[Cost Center])

where ListOfValues can reference an existing Table[Column] or List.

[Anonymous]

Hi, How should I write the name of the column that is a different table? and whow should I write it if there was a list?