I am using sql as my source data, and running reports for both Northern Ireland and Republic of Ireland. The data for each region is in separate tables. Is there a way I can convert the currency in the Northern Ireland tables to EURO before building my visualisations, so everything can be reported in single currency?
Thanks in advance for your help.
When you bring your data in could you not create a new column and then multiply the £ by todays € rate, I find Oanda.com good.
I'm not sure of a current way that the conversion rate could automatically update itself.
For currency conversion, I build a Slicer for change the currency. Then I wrote a formula to change the curreny:
For example suppose defualt currecy is Euro:
Euro_rate1= 1.05* US Dollar
Euro_rate2 =3378 * Irianian Rial (IRR)
IF(VALUES(Currency_Table[CurrencyType])="Dollar",FORMAT(SUM(Sales [Euro])/[Euro_rate1]),"$ #,##0.00;($ #,##0.00)") ,IF(VALUES(Currency_Table[CurrencyType])="IRR",FORMAT(SUM(Incentive_Table[Euro])/[Euro_rate2]),"€ #,##0.00;(€ #,##0.00)"),FORMAT(SUM(Incentive_Table[Euro])/1),"IRR #,##0.00;(IRR #,##0.00)")))
IF Currency Type="Dollar" Then Sales based on Euro/Euro_rate1
IF Currency Type="IRR" Then Sales based on Euro/Euro_rate2
Then format them.
Did you get it ?
I hope it is helpful.