Power Query Help

[VulcanPromance]

Hi. I have a global license system based in EURO, and I want to be able to show the license costs in various currencies based on a Country slicer. 

I have a Live Currency table

Which provides the live currency to table that translates Department names into country, currencies and other stuff

To be able to swap between currencies in visuals, I believe the best way would be to a have a seperate pricing column pr currency, so I have pricing table as well

Now.. in Power Query, I need to create x amount of new columns (1 for each currency found in Geography table) that calculates Price for that currency. Alternatively a less dynamic formula, that calculates for NOK, Dollar, SEK, DKK, PKR and any other Currency code I add into the formula manually).

See below for wanted output

I was not able to find this through searches..

I'm pretty sure its an easy nested IF statement, but I cant figure out how to make it work.. 

Tried this to see if I could just get the results across, but it only returns 0

if GeoData[Currency Code]= "NOK"
then GeoData[Currency rate]*Pricing[Price]
else 0

[v-frfei-msft]

Hi @VulcanPromance ,

I have a global license system based in EURO, and I want to be able to show the license costs in various currencies based on a Country slicer. 

---

As you said you want to achieve that by slicer. Then I think to create measures should be your best choice. Kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.