Forum Discussion
danielmarques
1 year agoAdvocate I
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...
- 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
1 year agoAdvocate II
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.