cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Memphis_JW
Regular Visitor

Add second, third, fourth criteria to column filter

I am new to Power BI.

 

This is the line that filters for one code - AE.

= Table.SelectRows(Work_Item_Country__c, each [Country_Code__c] = "AE")

This is me trying to add a second criteria ( I want to add up to four).

= Table.SelectRows(Work_Item_Country__c, each [Country_Code__c] = "AE","AU")

This is the error that I get.

Expression.Error: 3 arguments were passed to a function which expects 2.

 

Any ideas or suggestions? I am hoping this is a simple fix.

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

Please try writing with List.Contains M query.

 

List.Contains - PowerQuery M | Microsoft Learn

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi,

Please try writing with List.Contains M query.

 

List.Contains - PowerQuery M | Microsoft Learn

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors