Forum Discussion
HuskyMan
4 years agoNew Member
Product usage tracking multiple items in one row
Hello All, I am an avid Excel user, but I am new to Power BI and would like some direction. I created an example that mirrors what I am trying to achomplish. Scope: The owner of a used car de...
- 4 years ago
HuskyMan , One very clear as data shared above has different column than one in relation diagram.
But seem like unpivot the test drive 1, test drive 2, test drive 3 , is an option to be explored
https://radacad.com/pivot-and-unpivot-with-power-bi
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak
Super User
4 years agoHuskyMan , One very clear as data shared above has different column than one in relation diagram.
But seem like unpivot the test drive 1, test drive 2, test drive 3 , is an option to be explored
https://radacad.com/pivot-and-unpivot-with-power-bi
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.