Advanced Excel Power Query-M language, troubleshoot, Pattern

About this course

Hello and welcome to Excel Power Query Advanced course.At the outset I thank you for showing interest in this course.   In this video I will provide overview of all the contents of this course and what are basic requirements before you enroll into this course. So let’s get started.   There are four major areas I will be covering as part of this course. The first one is for troubleshooting the Power Query errors and workaround for limitation of Power Query. In real any software is not foolproof and has its own limitation. Also, if you don’t use the software as programmed you may encounter errors. And I hope you would agree that error codes or description in most of the software are not that user friendly or they do not provide appropriate solution to resolve the error. Hence in this first section I will show some of the common areas where you face Power Query limitation and erros. Some of them are as follows:   Error encountered with adding / rename / deleting a particular column headings.   Handling null values during arithmetic calculation.   Identify error rows encountered while creating or on refresh of query.   Multiplying effect when you JOIN queries   Issues with filters and how to use advanced filters.   Then the next area is for advanced case studies. Similar to my starter course of Excel Power Query where I have shown you more than 20+ real life case studies of applying power query, here also I have taken some real life case studies which require some more in depth knowledge of Power Query and workaround. This section will be updated new case studies as and when I see some interesting datasets. The current video are related to   Applying local setting when converting the dates fields   Leave dataset which needed leave details to be broken into separate rows from a single cell.