Pivot tables and relationships

Hi Guys,

i tried to do something similar like in youtube below:

https://www.youtube.com/watch?v=-Ijb4aKsAVc

I have two tables there:

Screenshot_51.png

And try to create pivot from 2 connections created from these tables.
I created relationships:

Screenshot_52.png

But still result in pivot table is strange.
It seems that this is not creating inner join between tables...

Why?

Best,
Jacek

I'm not answering your exact question, but it is possible using Power Query (see attached).

Hi kersplash,

thank you.
I know how to create use PQ.

Question is what is the difference where you are creating relationships using Power Pivot?
Why this is not working?

Best,
Jacek

Can't answer that. I've tried to use this method in the past and scratch my head too, so PQ it is.

thank you rorya !!

Best,
Jacek