Forum Discussion
SUMX DAX
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!
Not sure why you would need SUMX?
1 Reply
Not sure why you would need SUMX?