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
[TABLE="width: 128"]
<tbody>[TR]
[TD="width: 64"]INV[/TD]
[TD="width: 64"]Name[/TD]
[/TR]
[TR]
[TD]INV0001[/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]INV0002[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]INV0003[/TD]
[TD]Grape[/TD]
[/TR]
[TR]
[TD]INV0004[/TD]
[TD]Pineapple[/TD]
[/TR]
[TR]
[TD]INV0005[/TD]
[TD]Banana[/TD]
[/TR]
</tbody>[/TABLE]

Table 2
[TABLE="width: 128"]
<tbody>[TR]
[TD="width: 64"]INV[/TD]
[TD="width: 64"]IO[/TD]
[/TR]
[TR]
[TD]INV0001[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]INV0001[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]INV0001[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]INV0001[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]INV0002[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]INV0003[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]INV0004[/TD]
[TD]g[/TD]
[/TR]
[TR]
[TD]INV0005[/TD]
[TD]h[/TD]
[/TR]
</tbody>[/TABLE]

Current Outcome
[TABLE="width: 152"]
<tbody>[TR]
[TD]Name[/TD]
[TD]IO[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]g[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]h[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]g[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]h[/TD]
[/TR]
</tbody>[/TABLE]

Desired Outcome
[TABLE="width: 180"]
<tbody>[TR]
[TD]Name[/TD]
[TD]IO[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]Grape[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]Pineapple[/TD]
[TD]g[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]h[/TD]
[/TR]
</tbody>[/TABLE]

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/