Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Help: filter by two columns in power query

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks for your help!

It works perfectly.

 

Greetings

Monica

Anonymous
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.