Multiply rows in columns based on group

[Anonymous]

I'm trying to multiply these rows for each of them that have the same part no, description, and material form then put that value in a new row to determine their weight. The number of rows that it can pull with varies for different parts and the codes vary as well.

What I've done is break them up into individual columns based on the code they have.

Is this at all possible in Power BI?

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

please share your expected output in table format, thanks

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

It will end up looking something along the lines of this:

This is the template that was used in Excel but as long as it's got some similar details then a different design would be fine.