Subtotal and Column Total in Power Query

Check out our newly launched M Language course ↗️ - https://goodly.co.in/learn-m-powerquery/

Since there is no UI feature in Power Query to create a Totals Row we'll wrangle with the M language to create Row or a Column Total and even a Subtotal in Power Query.
I hope you enjoy!

Join this channel to get access to perks:
   / @goodlychandeep  

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
https://goodly.co.in/learn-dax-powerbi/

✔️ Power Query Course-
https://goodly.co.in/learn-power-query/

✔️ Master Excel Step by Step-
https://goodly.co.in/learn-excel/

✔️ Business Intelligence Dashboards-
https://goodly.co.in/learn-excel-dash...


===== LINKS 🔗 =====
Blog 📰 - https://www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/
Need my help on a Project 💻- https://www.goodly.co.in/consulting/
Download File ⬇️ - https://goodly.co.in/subtotal-and-col...


===== CONTACT 🌐 =====
Twitter -   / chandeep2786  
LinkedIn -   / chandeepchhabra  
Email - [email protected]


===== CHAPTERS =====
0:00 Intro
1:10 Part 1 - The Logic
2:30 Creating a Manual Record/Row
5:40 Creating the Automated Record using List.Accumulate
11:55 Inserting in the Record underneath the Table
14:45 Part 2 - Applying the Solution
19:11 My Courses


===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!