SUMX DAX

[Anonymous]

Dear community,

in my datamodel, I have a FACT table with values in local currency and a DIMENSION whith the exchange rates to calculate the EUR values. This works without any issues with SUMX on row level. 

FACT

Period	Month	Key Exchange Rate	Value	Currency
23 YTD	3	100	3000	Local
23 Forecast	3	200	12000	Local

DIMENSION (exchange rates)

Key Exchange Rate	Rate	Currency
100	1,01	EUR
200	1,04	EUR

My question:

I would like to substract from the 23 Forecast the 23 YTD value (both in Local) and then calculate the result with the exchange rate for 23 Forecast. With SUMX I did not found a working solution. Do you have any hint?

Cheers! 

[lbendlin · Accepted solution]

Not sure why you would need SUMX?