Relate 3 tables with exchange rate table

[djemy1975]

Hi colleagues,

Is there any way to relate 3 tables with values to an exchange table which has one fixed currency exchange rate all over the year.

In fact I have 3 tables with main currency "DZD"
Table1:"Booking"
Table2:"Engaged"
Table3:"To-be-engaged" ------These 3 tables are related to main table :"tbl_Projects" with Column-"Jobcost" and with another table "date Table" to be able to filter with month and year as slicers .This part is working perfectly.

What I want is to transform these data into another currency "CHF" which has a fixed rate in a table called "exchange table". The problem is when I want to filter with month and year slicer the matrix remains unchanged.
Shall I link "Date table" with "exchange table" or what?

 

[djemy1975]

I have found the solution for this problem after more than an hour trying.It was very easy.
I have changed my formula for "PO" , "PR" and "spending KCHF" by multiplying each value ("PO","PR", "Spending")in the 3 tables by rate in "exchange table", according to date in "Date table".

PO KCHF = Calculate([PO]*sum(ExchangeTable[ExchangeRate]);USERELATIONSHIP(Engaged1[Date GL];'Date'[Date]))
PR KCHF = CALCULATE([PR]*sum(ExchangeTable[ExchangeRate]);USERELATIONSHIP(To_be_enaged[Date GL];'Date'[Date]))
Spending KCHF = calculate([Spending KDZD]*sum(ExchangeTable[ExchangeRate]);USERELATIONSHIP(Booking2[Date GL];'Date'[Date]))

These are the screenshots after modification: