Forum Discussion
danielmarques
Advocate I
1 year agoResolving 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...
- 1 year ago
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.
ahmetyilmaz
Advocate II
1 year agoHi, 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.