Forum Discussion

odada11's avatar
odada11
Icon for Helper I rankHelper I
3 years ago

converting GBP TO USD

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 calcu...
Need Help
olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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

odada11's avatar
odada11
Icon for Helper I rankHelper I
3 years ago

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