Forum Discussion
Power Pivot GroupBy Function
I used GroupBy function in powerBI to help me show summary data, BUT in current project using Power Pivot, I can't find where to create a GroupBY table. If GroupBy function is omitted in Power Pivot? Is there a work around? Apprciate any support on this question.
Jeff
Anonymous
Once you have the power pivot add ins in excel, you should able to go to query editor directly, the group by option is same as the query editor in Power bi.AddPower Pivot For Excel: What It Is and How to Use It (lifewire.com)
Also see the gif image: Introduction to the Query Editor (Power Query) - Excel (microsoft.com)
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
2 Replies
The query editor is the same in both (just about), and the Group By button should be in the ribbon. Also, you can can always build your query in Power BI and then copy/paste it to Excel.
Regards,
Pat
Anonymous
Once you have the power pivot add ins in excel, you should able to go to query editor directly, the group by option is same as the query editor in Power bi.AddPower Pivot For Excel: What It Is and How to Use It (lifewire.com)
Also see the gif image: Introduction to the Query Editor (Power Query) - Excel (microsoft.com)
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
