Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    8 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

  • Anonymous's avatar
    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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for your help!

    It works perfectly.

     

    Greetings

    Monica