Forum Discussion
Solved
Convert currency
I need to convert the 'amount' column in the below table to EUR (currency is GBP at the moment), and then to merge the table with another that is already in EURO. So far I have not been able to do ...
This will work if you get rid of all of your non-GBP exchange rates. Do you need those? If you do, sure some more DAX magic can get you there.
Column = LOOKUPVALUE(ExchangeRates[ExchangeRate],ExchangeRates[CurrencyCode],"GBP",ExchangeRates[StartTime],MAX(ExchangeRates[StartTime]))
Oh wait, here is the additional DAX magic that will let you keep your other currency codes.
Column = LOOKUPVALUE(ExchangeRates[ExchangeRate],ExchangeRates[CurrencyCode],"GBP",ExchangeRates[StartTime],CALCULATE(MAX(ExchangeRates[StartTime]),ExchangeRates[CurrencyCode]="GBP"))
Hi Greg_Deckler,
So as you can see, my intent here is to be able to convert each individual invoice based on its date's exchange rate, not one final convertion at month end with only one exchange rate.
Could you advise on a way to do it?
Thank you for your help.
Fernando
Hello Greg_Deckler,
Sorry to insist. I'd just only like to know if there is a way I can solve my problem of currency conversion in Power BI.
Thanks and regards,
Fernando