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 Scrap...
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
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
