Currency Exchange from local currency to JPY

[guorong]

Dear PBI communittee, 

Would like to seek your advice on calculating exchange rate by month. 

I have no problem with single month exchange, but when it comes to cumulative, the exchange rate adds up and multiple over the total value (Sales, Cost, Expense, Operating Profit), I ended up with crazily huge result. I tried Productx,lookup, but have not been able to get my result right

Exchange Rate Table, all current financial information are in local currency (SGD, MYR,INR, etc)

Country Table - Use to define which company using

[guorong]

This is my main financial table, I'm using Company code to look up on currency in Country table

[FreemanZ]

hi @guorong 

how does your record table look like? or what measure do you have so far?

[ERD]

Hi @guorong ,

I believe you'll find all answers here:

Currency conversion – DAX Patterns

[guorong]

I will look into it.