Uploaded April 2026 | Updated November 2026, 5 days ago
Register for the Power Query Learning Festival - goodly.co.in/power-query-festival
Download the Practice File - goodly.co.in/5-nested-table-tricks-in-power-query
youtu.be/E6edg0ldufA?si=O-iyLIFdFEiNiX9E
youtu.be/OHCCuQDqgQE?si=N5QJqfUPv7OQKj1a
In this video, I walk through one of the most useful but confusing topics in Power Query - working with nested tables.
We start with the fundamentals and look at two basic ways to approach nested tables:
transforming the tables directly, or creating a new column and using those nested tables to calculate new values. From there, we go deeper into how to navigate rows, columns, and column names inside nested tables, how to do calculations with nested tables, and how to understand the context shift from the outer table to the inner table.
I also cover some very practical Power Query techniques like:
• extracting columns, rows, and column names from nested tables
• calculating things like averages from tables inside a column
• dynamically combining all columns from nested tables
• combining only the common columns across nested tables
If you’re learning Power Query M language, or you often work with nested tables, table functions, dynamic combine logic, and advanced data transformation, this video will help you understand the logic much better.
===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book
✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?
✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi
✔️ Power Query Course -
products.goodly.co.in/learn-power-query
✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the Practice File - goodly.co.in/5-nested-table-tricks-in-power-query
=====TIMESTAMP =====
0:00 - Intro
0:33 - Trick 1
4:38 - Trick 2
9:01 - Trick 3
16:21 - Trick 4
17:41 - Trick 5
===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== 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'll find a ton of interesting videos that I have created :) Cheers!
Register for the Power Query Learning Festival - goodly.co.in/power-query-festival
Download the Practice File - goodly.co.in/5-nested-table-tricks-in-power-query
youtu.be/E6edg0ldufA?si=O-iyLIFdFEiNiX9E
youtu.be/OHCCuQDqgQE?si=N5QJqfUPv7OQKj1a
In this video, I walk through one of the most useful but confusing topics in Power Query - working with nested tables.
We start with the fundamentals and look at two basic ways to approach nested tables:
transforming the tables directly, or creating a new column and using those nested tables to calculate new values. From there, we go deeper into how to navigate rows, columns, and column names inside nested tables, how to do calculations with nested tables, and how to understand the context shift from the outer table to the inner table.
I also cover some very practical Power Query techniques like:
• extracting columns, rows, and column names from nested tables
• calculating things like averages from tables inside a column
• dynamically combining all columns from nested tables
• combining only the common columns across nested tables
If you’re learning Power Query M language, or you often work with nested tables, table functions, dynamic combine logic, and advanced data transformation, this video will help you understand the logic much better.
===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book
✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?
✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi
✔️ Power Query Course -
products.goodly.co.in/learn-power-query
✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the Practice File - goodly.co.in/5-nested-table-tricks-in-power-query
=====TIMESTAMP =====
0:00 - Intro
0:33 - Trick 1
4:38 - Trick 2
9:01 - Trick 3
16:21 - Trick 4
17:41 - Trick 5
===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== 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'll find a ton of interesting videos that I have created :) Cheers!










