power query

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.

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…

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…

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 …

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

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

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

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

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

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

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…

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 …

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…

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 …

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 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

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

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.).

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

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…

Table.Group in Power BI and Power Query has a very powerful 5th parameter that's worth checking out. Case insensitive grouping is just one cool feature.

Selecting items from lists is often used for cleaning text-fields. List.SelectPositions allows you to select them by addressing their positions in Power Que