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/dynami...
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_con...
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: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#dynamic #groupby #m