Running Total multiple currency conversion to one

nauriso1

Apologies, missed that detail.

So the running total of transactions in each local currency is revalued daily in EUR at the current rate.

This measure will do the trick in the model you uploaded:

Running Total EUR = 
SUMX (
    dimCurrency,
    [Running Total]
        * CALCULATE (
            VALUES ( dimCurrencyExchange[Exchange Rate] ),
            LASTDATE ( dimCalendar[Date Key] )
        )
)

The LASTDATE(...) is just there to ensure correct calculation at a total level when multiple dates are selected.

Model uploaded with new measure here for reference

Cheers,

Owen