Making matrix from two or more different tables

[Edmund]

Hi there,
I have two excel sheets as data source and I need to make one matrix table in Power Bi as it is shown in picture. I've been trying create relationships but I didn't get result I wish (I'm quite new in PBI). Could you please help me?

 

[Matt Allington]

First read this.

The Optimal Shape for Power BI Data

It is common for self taught Power Pivot users to get the shape of their data all wrong. This article describes the optimal way to do it.

exceleratorbi.com.au

in your case, you have 2 data tables and no lookup tables. You need to create the lookup tables and join both your existing data tables to the lookup table(s)

then use the columns from the lookup tables on rows/columns in the pivot table, and put the numeric columns from the data tables into the values section.