topic Re: Currency Exchange from local currency to JPY in DAX Commands and Tips

Currency Exchange from local currency to JPY

guorong — Mon, 10 Apr 2023 07:19:29 GMT

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

Re: Currency Exchange from local currency to JPY

ERD — Mon, 10 Apr 2023 07:42:28 GMT

Hi guorong ,

I believe you'll find all answers here:

Currency conversion – DAX Patterns

Re: Currency Exchange from local currency to JPY

FreemanZ — Mon, 10 Apr 2023 08:07:43 GMT

hi guorong

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

Re: Currency Exchange from local currency to JPY

guorong — Mon, 10 Apr 2023 08:43:59 GMT

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

Re: Currency Exchange from local currency to JPY

guorong — Mon, 10 Apr 2023 08:44:21 GMT

I will look into it.