Multiple currencies conversion

Question

Hi everyone, I am new to Power BI and I am currently learning it.I am in this situation: I have a Sales table and a Currency table.The Sales table has information about the sales made by various shops and the Currency table has information about exchange rates.In the Sales table I have a currency column and a net value column:CURRENCY&nbsp; &nbsp; &nbsp; NET VALUEEUR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10USD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5EUR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5RUB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7Each net value column is in a different currency format given by the currency column, so I can't sum them.&nbsp;In the Currency table:CURRENCYFROM&nbsp; &nbsp; &nbsp;CURRENCYTO&nbsp; &nbsp; &nbsp;EXCHANGE_RATE_TYPE&nbsp; &nbsp; &nbsp;EXCHANGE_RATEEUR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,5EUR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,2USD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EUR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0,5etc. (I am using dummy values)&nbsp;For every possible conversion, I have multiple exchange rate types that must be filtered by using a slicer.&nbsp;What I want to do is to convert all the net values in a specific currency format given by a slicer: so I need 2 slicers, one to select the target currency and one to select the exchange rate type. Based on this information I want to convert all the different values in a single format.Note: the tables must be connected with the relationship between Sales(Currency) and Currency(CurrencyFrom) which leads to a many-to-many relationship.&nbsp;How to deal with this problem?

dan094 · Accepted Answer

I have no time dimension: the exchange rate is fixed. However, I managed to find a solution by creating some bridging tables to resolve the many-to-many relationship and then I found very helpful some dax code on https://www.daxpatterns.com/patterns/&nbsp;.&nbsp;

Forum Discussion

Multiple currencies conversion

2 Replies

Related content

Function currency conversion

Currency Conversion

Currency conversion

Multiple-Multiple Currency Conversion

currency conversion