Join two table

[OzgurKlc]

Hi All,

I have two tabel

table1

Product Code	Scarp code	Part Code	Year_Month
0101A	TYT	EBC	2023.01
0101A	EYT	GBC	2023.01

table2

ProductCode	PartCode	Qty	Scrapqty
0101A	EYT	5	3

relation table1.productcode = table2.productcode

I would like to get like below ,

YearMonth	ProductCode	PartCode	Total Qty	Total Scrap
2023.01	0101A	EYT	5	3

Can you assist?

Thx

[wini_R · Accepted solution]

Hi @OzgurKlc,

You can merged both tables in power query using 2 common fields between them: Product Code and Scarp/Part Code. Then just expand both quantity columns and apply any transformation steps if needed