Group By Function in Power Query

In this first of two videos I explore the Group By function in Power Query by illustrating what the function does and showing you have to use it. It's a really simple function to use but it is so powerful as it does all of the hard work of working out what to group and how to group it.

Just take a look at the short video on my YouTube channel and find yet another way in which Duncan's Diurnal Diatribe is paying for itself over and over.

From my Excel file:

My introduction in the file

The data on which all of these Group By examples are based

Just one example of how I used my Group By queries: see part two in this series for more examples

You can download my file from here

Part two in this two part series is here

Duncan Williamson

17th June 2024

Click this link ... https://youtu.be/GZSYG9YqXPE