Create Index Column By Group in Power Query
This video shows how to create an index column for each category in your table. Within each category the number then starts from 1 and increases sequentially up to the number of items in your category. Master Functions and Syntax in M https://powerquery.how 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... LET'S CONNECT: Blog: https://gorilla.bi Facebook: / bigorilla Twitter: / rickmaurinus LinkedIn: / rickmaurinus Thank you for your support! 00:00 Introduction 00:26 Add Regular Index 01:02 Method 1: Separate Column 03:15 Method 2: Adjust Group By - Lose Data Type 07:28 Method 3: Adjust Group By - Define Data Type #index #powerquery #bigorilla
Transform Column Names in Bulk in Power Query
Fast Running Totals in Power Query (Complete Guide)
Understanding Metadata in Power Query M
These 5 Custom Column Tricks Make Power Query Easier
Nested Lists in Power Query: You’ll Wish You Knew This Sooner
Power Query was HARD until I learned these 7 Tips
Add index to nested tables in Power Query
Advanced Group By Tricks in Power Query
Reduce Steps in Power Query - Tips Only the Pros Know!
Make your Group By Operations Dynamic in Power Query M
Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)
Power Query: Index and Modulo Functions
Nested Table Tricks That Save Hours of Power Query Work
Power Query - Index Column by Group & Return Last and First Record for a Group
List.Buffer: This One Power Query Function Can Speed Up Your Refresh
Return Previous Row Value in Power query
Power Query Secrets - Simple tweaks is all it takes.
Custom Comparer Function for Table.Group in Power Query M
