Nested Lists in Power Query might just be your new favourite trick!
In this video, I’ll show you how to create nested lists and apply them to real-life Power Query problems like:
✔ Replacing errors dynamically across all columns
✔ Dividing multiple numeric columns by 1000 — even when the column names change
We’ll break it down step-by-step, starting with basic list creation, building a list of lists and applying them to real transformations using a bit of M language.
This is not just a theory video—you’ll learn two practical and dynamic use cases you can apply to your own Power BI and Power Query work right away. If you're into the M language, this one’s a must-watch.
https://youtu.be/90atXaUhBec?si=hDT4jiuKPV6HxD5Z
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
https://goodly.co.in/learn-m-powerquery/
✔️ 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-dashboards/
===== 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/the-power-magic-of-nested-lists-in-power-query
===== CONTACT 🌐 =====
Twitter - https://twitter.com/chandeep2786
LinkedIn - https://www.linkedin.com/in/chandeepchhabra/
Email - [email protected]
===== 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!