Forum Discussion
Solved
Formula for Exchange Rate
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
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. :smileyhappy:
Measure = SUM ( Sheet1[Spend in USD] ) * MAX ( Sheet2[currency rates against USD] )
Regards
1 Reply
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. :smileyhappy:
Measure = SUM ( Sheet1[Spend in USD] ) * MAX ( Sheet2[currency rates against USD] )
Regards