Currency conversion

Hi all,

I have actual 2022, actual LY and budget 2022 data that I want to convert from local currency, to EUR figures (to be able to make visuals both in local currency as in euro).  How can I divide my local currency values with the proper currency rates?

My data is described below.

My Dataset: (These queries are connected through unique code, dates and currency ticker.)

1. A query 'Actual 2022' in the form of:

-a unique code referring to a customer

-a date

-actual values in local currencies

2. A query 'CMD Data' with Customer master data

-currency ticker

-market

3. A query with FX rates, looking like this:

-FX ticker

-Date

-rates for 2021, 2022 and Budget

4. A Date table

Best regards

Sander