Handling and calculate currency exchange

[mandiatutti]

Hi everyone. 

I need to graph the currency exchange rate by calculating it from the data i have about payements. Let me explain it better: I have a "MOVEMENTS" table in which i have the "MOV_VAL_GLOBAL" column which is the whole amount of the movement in EUR and a "MOV_VAL_LOCAL" column which is the whole amount of the movement in the local currency (USD, EUR, whatever it is...). Now i can calculare the exchange rate EUR/local_currency by adding a calculated column in the MOVEMENT table:

CURRENCY EXHANGE = DIVIDE(MOVEMENTS[Amount MOV_VAL_GLOBAL]; MOVEMENTS[MOV_VAL_LOCAL]). 

I need a graph that shows the exchange rate trend by date ( i have a calendar table). And I possibly want to chose the "foreign" currency too with a slicer, better if automatically detected by looking at the value in the "CURRENCY_LOCAL" field.

Can you help me with that? 

If you need more informations just ask me. Thank you. 

 

[v-juanli-msft]

Hi @mandiatutti 

Does "MOVEMENTS" table have "date" column, why not connect it directly with "calendar" table?

To show the exchange rate trend by date on a visual, please connect "MOVEMENTS" table directly with "calendar" table. ( it should be a solid line instead of a dashed line)

Where is "foreign" currency ?

When selecting "foreign" currency, what do you expect to see from the visual?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.