Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Can you modify rows in Power BI/Power Query?

Hello. I have multiple rows that need to be averaged into one row. They are multiple parts to the same piece of furniture. I have not seen any way to change rows in the program or online. 

4 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    Possibly a Group By in Power Query with an aggregation of average?

    That should start you but there's not enough detail in the question for more. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Group By is only letting me select columns. 

  • HotChilli's avatar
    HotChilli
    Community Champion

    Anonymous I can help you but you're going to have to give me more info.

     

    What have you got to start with? What do you want? Any explanations of how to get from one to the other.

     

    You can read the pinned post at the top of the forum if you like.