converting GBP TO USD

[odada11]

Good day all,

I am trying to create a DAX measure that helps me calculate The conversion rate 
I have Ticket no xxx1 and i have my daily exchange rate on my (Daily rate table)
I made this calculation IF ( Customers (Currency) = 'USD" && date of purchase < today  return  Ticket revenue* fxrate,
IF ( Customers (Currency) = 'USD" && date of purchase > today return  Ticket revenue* (max)fxrate,

Also i want to be able to calculate based on the fx rate for the selected date in the filter.(For instance if my manager selects 02/02/23, I want the visual to return revenue * the fx rate for 02/02/23).
pls i would appreciate any insights 

[olgad]

Ticket revenue*Calculate(max( fxrate), Filter(DailyRateTable, DailyRateTable.DateColumn=Selectedvalue(DailyRateTable.DateColumn))

[odada11]

Thank you so much, i want to be able to combine the measures, is this possible, also the Dailyrate and fxrate is one and same. i cant seem to apply it as you have written above