Daily Currency Conversion

[andrewb95]

I have a table as per below which shows a value per day in GBP. 

Date	Amount in GBP
01.01.2021	10
02.01.2021	15

I also have another table which shows the daily conversions:

Date	GBP to USD
01.01.2021	1.32
02.01.2021	1.31

I want to be able to add a column to the table A with the daily value in USD. 

Date	Amount in GBP	Amount in USD
01.01.2021	10	13.2
02.01.2021	15	19.65

Please advise on the calulation to get this daily based on the changing values per date.  

[smpa01 · Accepted solution]

@andrewb95  calculated column as following assuming no relationship

Column = CALCULATE(MAX(Conversion[GBP to USD]),FILTER(Conversion,Conversion[Date]=CALCULATE(MAX(GBP[Date])))) * CALCULATE(MAX(GBP[Amount in GBP]))

same result assuming there is a relationship

Column = RELATED(Conversion[GBP to USD])*GBP[Amount in GBP]