Forum Discussion

RobRayborn's avatar
RobRayborn
Icon for Helper IV rankHelper IV
4 years ago

Currency Conversion

I have a fact table of Sales from three facilities. Two work in Euro and one in GBP.   I have a full Date table with conversion for EURO, GBP and USD. This works, line by line, but the total isn't co...
currency conversion
DAX Commands
DAX Commands and Tips
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
4 years ago

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.