A Big Announcement & 5 Advanced Data Cleanup Examples in Power Query

Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
In this video, I discuss five advanced data cleanup examples in Power Query that cannot be solved using the user interface alone. These examples include the double headers problem, working with pivoted data, combining data from multiple Excel files, and solving custom delimiter problems. #PowerQuery #MLanguage #Excel
Data Cleaning Case Studies -
Promote Double Headers in Power Query | Solution - • Promote Double Headers...
Unpivot Cross Tabulated Data with Multiple Headers and Columns - • Unpivot Cross Tabulate...
Combine Data from Multiple Excel Files with Inconsistent Column Names - • Combine Data from Mult...
Advanced Power Query Case Study 🔴 (with downloadable files) - kzbin.infoyx7rg3NA...
Solving Tricky Data Cleaning Problems using M in Power Query -kzbin.info_ZKT1raC...
===== ONLINE COURSES =====
✔️ M Language course
goodly.co.in/learn-m-powerquery/
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/big-ann...
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== 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!

[@GoodlyChandeep]

Learn to build robust Excel/Power BI models by creating dynamic queries using the M language, complemented by many real-life case studies and practical examples➡ goodly.co.in/learn-m-powerquery/

[@randomguy-jo1vq]

I would really appreciate it if you could tell is your m code different than the topics you already covered on youtube ? Does it include the foundation of m language ?

[@sujit3375]

❤ .. finally super duper M code is out many many congratulations 🎉Chandeep.. Lots of love to Goodly as well

[@ushakiranmai3019]

Hi chandeep, could you please suggest me if there is work around to remove the empty spaces in the matrix visual based on the slicer selection in Power BI.

[@ramandeepsr]

Hi Chandeep, Thank you for all the knowledge you share as they helped me and others a lot. I have one problem wherein suggestions are required to solve that - I wanted to check three consecutive occurrences of an error basis which I will mark the status. For an example - If a person is sales less than $1000 in first month, the status should be reflected as 1st Occurrence, in case of less sales in second month, it should be reflected as 2nd Occurrence and in same case of third, it should be reflected as Final Occurrence however the glitch here is that in case he achieves more sales in second month, it should be reset and needs to be started at 3 month to check for first occurrence and in case he achieves target in third month, it is good to go.

[@mahathmasadineni2884]

Hi Chandeep, Can you create a vedio something like where we have to display how the no of records are changing in sources file based on time and along with some KPI Metrices. for examples we have data model with 3 input files we will refresh it start of month mid of month and end of month. We need to create a Data Summary sheet with how data is available at the 3 times and how the KPI Metrices are at the 3 times..

[@randomguy-jo1vq]

Hi chandeep. I watched almost all of your videos and no doubt you are one of the best M code teacher on net.

[@GoodlyChandeep]

Thank you. Humbled :)

[@_ni._sha]

💯

[@ericrobbins6953]

Awesome content as always. Chandeep, are there M code books you recommend?

[@randomguy-jo1vq]

He recommended in his old videos

[@GoodlyChandeep]

writing one :)

[@ericrobbins6953]

@@GoodlyChandeep wow, I can't wait. I signed up for the three module bundle package. Can't wait to get into that as well. Thank you Chandeep for all you do.

[@oscararmandocisnerosruvalc8503]

Bro please help us to inject html scripts in power query , to perform regex or any other cool script :)

[@FaisalAli-km3xw]

sir please make a video on Kaggle messy data for data cleaning

[@GoodlyChandeep]

please send me the data and the expected output. - [e-mail]

[@randomguy-jo1vq]

I would really appreciate it if you could tell is your m code different than the topics you already covered on youtube ? Does it include the foundation of m language ?

[@thebhaskarjoshi]

Yeah! I've the same doubt.

[@GoodlyChandeep]

Here is how the course is different than KZbin. - I start from the basics and every lecture is placed in a logical order along with exercises. - You tend to learn a lot even from the comments that other students post. - I cannot invent new topics but in a course I can cover boring subtleties that people would not be interested while watching a youtube video. - most importantly, because you paid money for it there is a high chance that you'll finish it and even ask questions. - - - One side benefit that I get - I pay my bills and keep making quality content :)

[@randomguy-jo1vq]

@@GoodlyChandeep thank you. These reasons are enough for me to sign up for this amazing program 😀

[@GoodlyChandeep]

@@randomguy-jo1vq see you inside :)