Forum Discussion
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
- HotChilliCommunity 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.
- AnonymousNot applicable
Group By is only letting me select columns.
- HotChilliCommunity 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.
- v-jingzhangCommunity Support
Hi Anonymous
Can you share some sample data and expected result? We can help seek for a possible solution based on that. See How to provide sample data in the Power BI Forum
Regards,
Community Support Team _ Jing