Forum Discussion
DAX to convert currency?
Hi all, My reporting needs to be captured in one currency - EURO. One of my tables is in GBP so I need to convert everything in this table to EURO and then to append this with my EURO table. I ...
trebgatte
Most Valuable Professional
Most Valuable ProfessionalI agree with Eric, though I'd externalize the conversion table for easier maintenance. Most corporate finance groups have a fixed conversion rate for a time period rather than using the market rate.
Perhaps you can put this in a centralized XLSX or a SharePoint list so that it can easily be updated without having to do anything to the PBIX.
Thanks for your responses - below is the table, the Amount column is the one I need converted as it is currently GBP (my reporting needs to be in Euro), and the table below it has the currency conversion rate.
I'd appreciate any help on the how to construct the formula to do the conversion?