Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Multiply rows in columns based on group

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?

 

Need Help

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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.