multiple currencies to single currency

VeerBI — Tue, 25 Apr 2023 10:14:26 GMT

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.

Re: multiple currencies to single currency

tamerj1 — Tue, 25 Apr 2023 10:53:36 GMT

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 )

topic Re: multiple currencies to single currency in DAX Commands and Tips

multiple currencies to single currency

Re: multiple currencies to single currency