Combine and Summarize multiple BOM/Tables into one table by sheet name

[Anonymous]

I have several BOM's for different products. They all list the components and their SAP Part Numbers, but I want to create a summarized table of these BOM's in PowerBI to have the rows list the material summarized and the Columns list the BOM name in said sheet to summarize the qyantity. How could I make it look like this in my new table using DAX or some other method. Any help would be appreciated.

[Anonymous]

Hi @Anonymous ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu