Forum Discussion
Solved
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 provide...
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.