Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
Thanks for your help!
It works perfectly.
Greetings
Monica
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
User | Count |
---|---|
73 | |
70 | |
38 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
43 | |
42 |