Forum Discussion
Calculated new rows with filter
Hi all,
I have a table that looks like this:
The problem is that the Online Price for country UK is in Pounds and the Online Price for other countries is in Euro.
I would like to add a row to the table when country is UK that calculates the price in EURO that gets a different country name : UK in Eur. I already have the exchange rate loaded in a measure called "EUR per unit for GBP"
So it would look something like this:
Gerald23 , My suggestion would be to add a new column not a row
refer if needed
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
https://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2
2 Replies
- amitchandakSuper User
Gerald23 , My suggestion would be to add a new column not a row
refer if needed
https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/
https://radacad.com/currency-exchange-rate-conversion-in-power-bi-with-live-rates-part-2
- Gerald23Helper I
Thanks this helped me to make it work for now 🙂 I added a column currency based on country and setup the relationship with the exchange rate table. Then I was able to multiply the online price by the exchange rate now it also shows the UK prices in Euro which is good enough for now.