Power Query

Announcement Update: For those who missed out on the webinar Watch the Session Recording for my (Avi Singh) webinar. Click here to watch the session record

Unpivot is one of the most frequent tasks when working with dirty data. Get this new "swiss-army knife-function" for all things unpivot:

Bill of materials (BOM) implosion analysis shows where each component is used. See how easily this can be done using M in PowerBI or Power Query in Excel:

Do you often find yourself in dire need to compare two tables in Excel? In today’s blog post, we will create an Excel workbook that compares two tables, and highlights the changes in a third table. You can load new versions of the tables, click Refresh All in Excel, and immediately see the changes in …

How we reduce development lag when building queries in Power Query is a question that came up in my blog post at PowerPivotPro last week, even though that wasn't the main issue.  I thought it might be a good idea … Continue reading →

Learn how to use Power Query like a pro and organize your queries by using this very simple technique. Take your queries and organize them in folders.

Power Query is a very powerful tool. It has a rich interface from which users can easily clean and reshape their data.   Table.Unpivot is one of my favourite feature. It IS a real game changer for cleaning data because business users tend to "build their data in the format that a PivotTable produces...

Over the last couple of years, I have been actively involved in doing Power BI trainings for my clients. Because of that, I am always looking for new and easier ways to explain Power BI concepts to…

Automatically transform all columns to the types that have been detected in the cells of its first row: Table.TransformColumnTypesToFirstRowsTypes

In Excel Power Query, I have a table. Column A has single numbers. I want to mark those records where the Column A value matches a list. A cutdown version of the problem is: let TableA = Ta...

In the past I did create a blog post where I demonstrated how to get the location of a user based on an IP Address What I did forget to elaborate on and what really makes Power BI even more powerfu…

Easy way to expand a complex JSON record without loosing the information that is visible already. Works for star schema and for big flat table

This is a quick tutorial on how to analyse M-functions step-by-step. Invoking a function will only get the results - see how to follow every single step.