Solved: Filtering data

kjani · ‎09-08-2021

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

amitchandak · ‎09-08-2021

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

mussaenda · ‎09-08-2021

Hi @kjani ,

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

amitchandak · ‎09-08-2021

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube