Get exchange rate from Exchange Rate table with only starting date

[Danch89]

I have a table with exchange rates holding only the starting date of the exchange rate. I have another table for daily sales data. I want to calculate the exchange rate on the day in the Sales table based on applicable starting date. 

For example.

Exchange table

Starting Date	Rate
01/01/22	1.2
04/01/22	1.5
08/01/22	1.7

Sales table with expected exchange rate from table above.

Sales Posting Date	Expected Exchange rate
01/01/22	1.2
02/01/22	1.2
05/01/22	1.5

[amitchandak · Accepted solution]

@Danch89 , A new column

new column =
var _max = maxx(filter(Exchange, Exchange[Starting Date] <= Sales[sales posting date]), Exchange[Starting Date])
return
maxx(filter(Exchange, Exchange[Starting Date] =_max), Exchange[Rate])