Help: filter by two columns in power query

[Anonymous]

Hello! 

I hope some one could helpme with this:

I have a table that is read from sharepoint with a column, later that table I convert it into a list to filter another table by the values it contains.
I use the following expression:  #"Filtered Rows" = Table.SelectRows(#"MySource", each List.Contains(Agr, [SUP_CODE]))

So far everything is correct, but I want to add that filter the value of the list as well as the value of the country = TX, when I add this to the expression does not bring me results when I have results to show, then I used this expression: #"Filtered Rows" = Table.SelectRows(#"MySource", each List.Contains(Agr, [SUP_CODE] and [COUNTRY] = "TX")) when I added and [COUNTRY="TX"] dont showme the result, I want the two conditions.

Thanks for the help

Monica

[Anonymous]

Thanks for your help!

It works perfectly.

Greetings

Monica

[v-shex-msft · Accepted solution]

HI @Anonymous,

List.Contains function not support your operation, please move second condition out of that function.

#"Filtered Rows" = Table.SelectRows(#"MySource", each List.Contains(Agr, [SUP_CODE]) and [COUNTRY] = "TX")

Regards,
Xiaoxin Sheng