Uploaded November 2025 | Updated September 2026, 3 weeks ago
Register for the Power Query Learning Festival on 10 & 24 May 2026.
Join the live masterclasses, take part in quizzes, win prizes, and get access to special offers
Register here → goodly.co.in/power-query-festival
Become an Insider today and gain access to the exclusive Power BI community, all of my advanced courses, monthly live sessions, and Monkey Tools Pro, everything at one price. Join now → products.goodly.co.in/learn-m-powerquery
Learn more about the Goodly Insider Here - youtu.be/Ac8PSwh0iqM
In this video, I walk through some of my favourite Power Query M functions and, more importantly, how they show up in real-life data cleaning work. You’ll see when to use Folder.Contents instead of Folder.Files, how List.Select and List.Transform can help you target just the columns you need, how to drive Table.TransformColumns dynamically, how records let you build multiple calculated columns in one step, and how Table.Skip can remove messy top rows even when the junk isn’t a fixed count. Along the way, I show the full thought process so you can reuse these patterns in your own projects instead of just copying code. There’s also a small secret-word challenge in the video: if you spot it and comment it within 7 days of release, you stand a chance to get 12 months of free access to the Goodly Insider community.
youtu.be/E6edg0ldufA?si=lTpik39eL3EQKaGd
youtu.be/1fn8fXYw6M4?si=x0jbWGios5XZ2kzk
===== 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
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the File ⬇️ - goodly.co.in/coolest-power-query-functions
===== 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 on 10 & 24 May 2026.
Join the live masterclasses, take part in quizzes, win prizes, and get access to special offers
Register here → goodly.co.in/power-query-festival
Become an Insider today and gain access to the exclusive Power BI community, all of my advanced courses, monthly live sessions, and Monkey Tools Pro, everything at one price. Join now → products.goodly.co.in/learn-m-powerquery
Learn more about the Goodly Insider Here - youtu.be/Ac8PSwh0iqM
In this video, I walk through some of my favourite Power Query M functions and, more importantly, how they show up in real-life data cleaning work. You’ll see when to use Folder.Contents instead of Folder.Files, how List.Select and List.Transform can help you target just the columns you need, how to drive Table.TransformColumns dynamically, how records let you build multiple calculated columns in one step, and how Table.Skip can remove messy top rows even when the junk isn’t a fixed count. Along the way, I show the full thought process so you can reuse these patterns in your own projects instead of just copying code. There’s also a small secret-word challenge in the video: if you spot it and comment it within 7 days of release, you stand a chance to get 12 months of free access to the Goodly Insider community.
youtu.be/E6edg0ldufA?si=lTpik39eL3EQKaGd
youtu.be/1fn8fXYw6M4?si=x0jbWGios5XZ2kzk
===== 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
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the File ⬇️ - goodly.co.in/coolest-power-query-functions
===== 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!
