Product usage tracking multiple items in one row

[HuskyMan]

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 dealership wants to track what vehicles are being test driven. Sometimes a salesman will test drive multiple cars on one day. 

Picture of Excel data

 

This is how I would like to display the data in Power BI

I am able to create a relation between test drive 1 and the product details of each car; however, I cannot determine a way to connect all test drives to the product details. I have tried adding relationships, but I can only have one relationship active.

An example of what I am trying to show is the month of January should have seven test drives. 

If its an easy solution that I am missing and there are places where I can learn, please let me know!

Thank you!

[HuskyMan]

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.  

[amitchandak · Accepted solution]

@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.