Group By Function in Power Query Part Two

Explore what you can do with the outputs from your Group By work in Power Query Part 2

In this second video in my two part series about Group By in Power Query, this video illustrates some of the ways in which you can work with the results of your Group By work. Group By is so simple to use but it provides some real insights into your data at the expense of little effort!

Here are some screenshots from my Excel file

My introduction worksheet

Example 1 of how I used a Group By query

Example 2: in which I separated my slicers and graphs from the query, found on another worksheet

Example 3, using a Pivot Table

Upload my Excel file from here

Part one of this two part series is here

Duncan Williamson

17th June 2024

Link to my YouTube channel and video two of my Group By series video two of my Group By series