DAX

[Nino1]

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!

[technolog · Accepted solution]

Hi!

You should use:

SUM([total revenue])*RELATED([Currency Rate]) - 

CALCULATE(SUM([revenue total])*RELATED([Currency Rate]) , DATEADD('Calendar'[Date], -1, MONTH))

[Nino1]

Thank you very much!