PowerPivot - Consolidating 2 Tables

[Laettner]

I am new to PowerPivot and require some help in consolidating 2 tables.

I've imported the data in PowerPivot and created a relationship between the "INV" field in both tables:

Table 1

INV	Name
INV0001	Apple
INV0002	Orange
INV0003	Grape
INV0004	Pineapple
INV0005	Banana

<tbody>
</tbody>

Table 2

INV	IO
INV0001	a
INV0001	b
INV0001	c
INV0001	d
INV0002	e
INV0003	f
INV0004	g
INV0005	h

<tbody>
</tbody>

Current Outcome

Name	IO
Apple	a
Apple	b
Apple	c
Apple	d
Apple	e
Apple	f
Apple	g
Apple	h
Banana	a
Banana	b
Banana	c
Banana	d
Banana	e
Banana	f
Banana	g
Banana	h

<tbody>
</tbody>

Desired Outcome

Name	IO
Apple	a
	b
	c
	d
Orange	e
Grape	f
Pineapple	g
Banana	h

<tbody>
</tbody>

Unfortunately when i run my pivot table i don't get the desired result. What should i change to correct my table to get the desired outcome?

Thanks for your help!
Chris

 

[Matt Allington]

The journey is long, but worth it. This is a good place to start relating to your problem. https://exceleratorbi.com.au/relationships-power-bi-power-pivot/