Forum Discussion
Currency Conversion
You haven't really provided enough info for me to advise you completely, but I suggest a different approach. You should always Sumx over the smallest possible table
SUMX(CALENDAR,
CALCULATE(SUM(Sales[Value]))*calendar[conversion column])
this assumes one row per date and 3 different conversion columns. Above is for one.
you could expand for 3 conversion columns with a calculate to filter sales for each currency to convert. It's a bit hard for me to say without seeing it.
I was able to determine that the DAX measure I am using is working as expected. The problem ended up being a rounding issue. The total Sales amount or [Daily Sales GBP] is a SUMX measure that gets rounded due to converting it to a Whole Number type, however once it takes into effect the Currency Conversion (at each row amount) the rounding for the converted amount is no longer rounded. at that point converting it to a Whole number re-rounds the amount and increased the overall annual amount by about 10K.
I ended up going backwards and doing my GBP and EURO conversion amounts on Power Query side.