Add second, third, fourth criteria to column filter

[Memphis_JW]

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.

[Jihwan_Kim · Accepted solution]

Hi,

Please try writing with List.Contains M query.

List.Contains - PowerQuery M | Microsoft Learn