Formula for Exchange Rate

[mahra-in]

I have the excel data with Spend in USD and another sheet with different currency rates against USD. Finally when I choose the a particluar currency in the dashboard I want all the reports to show the values in the currency I choose.

Please help

[v-ljerr-msft · Accepted solution]

Hi @mahra-in,

If I understand you correctly, you should be able to use the formula below to create a new measure to calculate the Spend against the selected currency rate. 

Measure = SUM ( Sheet1[Spend in USD] ) * MAX ( Sheet2[currency rates against USD] )

Regards