Make your Group By Operations Dynamic in Power Query M

Grouping data using the user interface hardcodes both column names and types. When your data changes, you then risk running into errors. This video shows different strategies to make your query logic dynamic and prevent errors. WRITTEN ARTICLE: https://gorilla.bi/power-query/dynamic-group-by-operations/ I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:29 Issue 1: hardcoded columns and types 03:04 Combining Tables 07:05 Scenario 2 08:21 Creating a Table Type 13:28 Issue 3: Expanding Hardcodes Columns 13:48 Dynamically Expand Columns LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #dynamic #groupby #m