multiple currencies to single currency

[VeerBI]

Hi All,

I have two tables transactions and Exchangerates. created two measures one to get the exchange rates for multiple currency and other to get the total amount (amount X exchange rate). When we deal with multiple exchange rates my measure does not give me total for that particular company.

How should i iterate through all the rows multiplying exchange rates with the respective amount.

Appreciate if someone throw some light on it.

[tamerj1]

Hi @VeerBI 
Please try

ReportingCurrencyMeasure =
VAR GBPRate = [ExchRateMeasure] * 0.01
VAR USDRate = 0.375
RETURN
    SUMX (
        Transactions,
        VAR ExchangeRate =
            SWITCH (
                Transactions[REPORTINGCURRENCY],
                "GBP", GBPRate,
                "USD", USDRate,
                1
            )
        RETURN
            Transactions[ACCTINGCURRAMOUNT] * ExchangeRate
    )