Our next Vancouver #PowerBI and Modern #Excel meet-up is July 11 at 10am PDT. We'll be exploring custom comparer functions in #PowerQuery for things like grouping and sorting with Microsoft MVP Rick de Groot. 🤓 Sign up here: meetup.com/vancouver-powe… (Session will be recorded.)

Dynamic Group By Operations in Power Query M from Rick de Groot buff.ly/3xngLiB #PowerQuery

When you group your data in Power Query, it hardcodes columns and data types. This can lead to errors if your data changes. Here's how you can make your queries dynamic youtu.be/ijpS0JQx0ko?si… I wish I knew this technique years ago! 😋

Power Query has an ellipsis operator, and it can save your code from disaster. I promise, you'll learn something new in under 2 minutes. 📽️ : youtu.be/i842G9m6YOg?si… Enjoy!