Forum Discussion
Solved
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...
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.
Are you asking for my data in this format?
| Date | Salesman | Test Drive 1 | Test Drive 2 | Test Drive 3 |
| 1/1/2021 | Jim | Focus | Prius | |
| 1/7/2021 | Bob | F150 | Escape | Corolla |
| 1/13/2021 | Mike | Escape | Corolla | |
| 2/5/2021 | Bob | Prius | Corolla | RAV4 |
| 3/5/2021 | Mike | Corolla | ||
| 3/23/2021 | Mike | RAV4 | ||
| 3/25/2021 | Bob | RAV4 | Prius | |
| 3/25/2021 | Bob | Escape | ||
| 3/25/2021 | Bob | Fuision | ||
| 4/4/2021 | Jim | Prius | F150 | Corolla |
| 4/8/2021 | Jim | Focus | ||
| 4/9/2021 | Mike | F150 | Escape | |
| 4/12/2021 | Bob | Focus | ||
| 5/13/2021 | Mike | RAV4 | Prius | |
| 6/5/2021 | Jim | RAV4 |
| Car | Manufacturer | Class | Price |
| Focus | Ford | Sedan | 18500 |
| Prius | Toyota | Hybrid | 24000 |
| Escape | Ford | SUV | 25000 |
| RAV4 | Toyota | SUV | 27000 |
| Corolla | Toyota | Sedan | 20000 |
| F150 | Ford | Truck | 30000 |
So basically that feature seperates the row into multiple entries to format the data for Power BI. I think thats the solution I needed.