Visual Studio 2017 and the SQL Server Data Tool (SSDT), a tool that comes with Visual Studio, finally integrates the now familiar Query Editor (Power Query) capability to work with the Analysis Ser…

This post shows how to write documentations for custom functions in M for Power Query for Excel and Power BI Desktop, by modifying metadata.

Let's take a deep dive into understanding how the each keyword in Power Query, which is used by quite a few of the built-in operations (filtering, custom columns, etc.).

My new function Text.RemoveRepeatingCharacters cleans up badly formatted text where spaces or other separators are applied multiple times.

Hello P3 World! My name is Krissy Dyess and I have had the most amazing experience working as a full-time consultant at Power Pivot Pro since April 17, 201

The Query Editor in Power BI/Excel Get&Transform/Power Query has a number of built-in ways to filter data in date columns relative to the current date, such as the “In the Previous” option. How…

Hello Everyone! In this episode of the “Problem, Design, Solution” series we will be talking about the “Folder” option inside the sources display for Power BI Desktop. This is a fantastic feature …

A new, as-yet undocumented, M function appeared in the December 2017 release of Power BI Desktop (I assume it will appear in Excel soon): Text.Select. Here’s the documentation from the Query Editor…

I am excited to share with you an excerpt from the draft manuscript of my book. You can also add it to your list in Amazon here. I expect to publish more excerpts in the coming months, so please stay tuned, and subscribe to DataChant. Appending Worksheets from a Workbook Excerpted from the draft manuscript …

One of my favourite features in Excel and Power BI is Power Query / M – and I just wanted to share a small trick when you want to filter a table on specific items. Let’s imagine you want to f…

If you want to quickly create a list with all dates (or specific intervals) between 2 dates, this function is for you: Date.DatesBetween

Here’s a really common problem that occurs when combining data from multiple files, or indeed any ty...

Ever looked at a Power BI report visual and wondered what the logic was behind a calculation? In mos...

This post continues series of articles about M Function List.Zip ( first post, second post). Table.T...

Following on from my post last week about M functions that are only available in custom data extensi...

The Advanced Editor is where I LIVE and BREATHE when using Power Query, so welcome to my universe.

The November 2017 release of Power BI Desktop contains a new M function: Function.From. Here is the function’s description from the official documentation: Takes a unary function function and creates …

This is my second post about List.Zip. First one was about general usage of List.Zip, where I touched question of transforming column types in Power Query. Another scenario where List.Zip can be us…

There is one useful Power Query M function - List.Zip, but with poor documentation on MSDN. I hope, at some point, library of M functions will be available on Github like it is done for VBA. Power Que…

The environment concept is one of the most important concepts in M, while it is one of the least obvious ones. We'll show why it is important to understand.

The environment concept is one of the most important concepts in M, while it is one of the least obvious ones. We'll show why it is important to understand.

Ages ago I posted an article on unpivoting subcategories using Power Query. The technique is still valid, but what happens when you have a large data set?

Power-Query-Cheat-Sheet - Power Query Cheat Sheet