Forum Discussion
Solved
DAX
Hello everyone
I'm a new user of Power bi and need your help.
I have two tables: one for total revenue and one for exchange rate.
| date | currency | total revenue | total revenue in USD | date | currency | Currency Rate | |
| 5/31/2022 | EUR | 10000 | 8000 | 5/31/2022 | EUR | 0.8 | |
| 5/31/2022 | USD | 20000 | 20000 | 5/31/2022 | USD | 1 | |
| 6/30/2022 | EUR | 10000 | 9000 | 6/30/2022 | EUR | 0.9 | |
| 6/30/2022 | USD | 20000 | 20000 | 6/30/2022 | USD | 1 |
I want to calculate difference between currenct revenue in dollar and revenue in dollar adjusted with previous month exchange rate. e.g. (20000+9000) - (20000*1+10000*0.9)
Could you please help me to solve this problem?
Thank you very much!
Hi!
You should use:
SUM([total revenue])*RELATED([Currency Rate]) -
CALCULATE(SUM([revenue total])*RELATED([Currency Rate]) , DATEADD('Calendar'[Date], -1, MONTH))
