Forum Discussion
Pivot Table using Dataflow Gen2
Hey all
Can we create a pivot table using Dataflow Gen2 as we do in Excel? I want the exact Pivot table, but not able to acheive it. Any examples would help.
Appreciate yoru help.
Hi jashfabric
Thanks for using Fabric Community.A Pivot Table has different layouts. Typically the "compact" view is something that goes beyond just a pivot table and goes into the visualization aspect. Power Query matches the "tabular view" layout that a pivot table can have in Excel. We do recommend using other tools, such as pivot tables or Power BI, for analytical purposes as Power Query is primarily aimed to be a Data Preparation tool.
Below is the documentation on how to pivot columns in Power Query:
Pivot columns - Power Query | Microsoft Learn
Hope this helps. Please let me know if you have any further questions.
2 Replies
Hi jashfabric
Thanks for using Fabric Community.A Pivot Table has different layouts. Typically the "compact" view is something that goes beyond just a pivot table and goes into the visualization aspect. Power Query matches the "tabular view" layout that a pivot table can have in Excel. We do recommend using other tools, such as pivot tables or Power BI, for analytical purposes as Power Query is primarily aimed to be a Data Preparation tool.
Below is the documentation on how to pivot columns in Power Query:
Pivot columns - Power Query | Microsoft Learn
Hope this helps. Please let me know if you have any further questions.Thanks Anonymous for your quick help as always.
