Forum Discussion
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
- Anonymous8 years ago
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
2 Replies
- AnonymousNot 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 - AnonymousNot applicable
Thanks for your help!
It works perfectly.
Greetings
Monica