Power Query Hack vs Pivot Table with Dynamic Arrays - Excel Report
When you create an advanced report in Excel, you might have different options or combination of tools.
In this tutorial, I create an advanced Excel report using Pivot tables along with Dynamic Array Functions. Then I create the same report using a little trick in Power Query.
Let me know in a comment which method you prefer.
Now, let’s have a look.
To book a Corporate Training anywhere in the World check
www.OfficeInstructor.com
Here is a contribution from a Friend to the Channel (Thank you Ivan Cortinas):
We add the table to the data model. We create 2 measures.
If the name of your table is Group3...
TotalSales:=SUM(Group3[Sales])
SalesCustomerList:=CONCATENATEX(VALUES(Group3[Customer]),Group3[Customer],", ")
Then you create Pivot Table from Data Model and move Region and Manager to Rows and move the measures TotalSales and SalesCustomerList to values.