Forum Discussion
Resolving Many-to-Many Relationships for Accurate Revenue Conversion in Power BI
My Objective: My Revenue column isn't accurate. It currently displays all values in USD, but I need to properly convert them based on the annual exchange rates for each country (the example I provided below is just a simulation of my actual data).
I manually created Table 2 in Power BI with the correct exchange rates, and am trying to link the two tables before I create the measures, but it only allows for a many-to-many relationship, which is creating quite a bit of confusion.
Does anyone have any suggestions on how I can achieve this goal?
Hi, Create a new Key column by concatenate Country and Date using a calculated column, so there will be a one-to-one relationship. Keys are unique in both tables.
2 Replies
Hi, Create a new Key column by concatenate Country and Date using a calculated column, so there will be a one-to-one relationship. Keys are unique in both tables.
Thank you, @ahmetyilmaz. The solutions you recommended worked perfectly. I created a unique key for both tables and established a many-to-one relationship. As a result, I was able to develop new measures to calculate the exchange rate and accurately update the revenue for each country.
