Filtering data

[kjani]

I have three columns in Power Query: Version, Currency, Data

If Version = BP, select Currency "USD" and "USD_PY"

If Version = PY, select Currency "USD"

How do accomplish this filter? Thank you

[mussaenda]

Hi @kjani ,

May I know why 2 are selected if the version is BP?

[amitchandak · Accepted solution]

@kjani ,expected output is not clear. Are you trying to control slicer?

if you need a new filter column, you can try like

if ([Version] = "BP" and [Currency] = "USD" ) or ([Version] = "BP" and [Currency] = "USD_PY") then 1
else id [Version] = "PY" and [Currency] "USD" then 1 else 0