Power Query: Custom Grouping Using M (Based on a Student Question)
I received a tricky question from one of my students about grouping in Power Query (Table.Group). While preparing the example, my imagination ran wild, and I made the task more challenging.
In this video, we'll look at several examples of non-standard table grouping, including grouping using formulas written in the M language.
File here: https://yadi.sk/d/si_ux5utxQHS8Q
I invite everyone interested in mastering Power Query to my course "Developing Power Query Queries in Excel (with M language learning)."
Course description and registration are available at the following link: https://bit.ly/3ofVZrr
You can master the basics of Power Query in my free course "Power Query Basics."
Course description and registration are available at the following link: https://bit.ly/3jlC5rx