Author: Ken Puls

There was a really cool new feature added in the latest Power Query update:  The ability to split Power Queries.  This is something that has always been possible by editing the M code manually, but this makes it super simple.

When working with Power Query, it’s actually pretty simple to restrict records in a table using an AND criteria.  As filters on different columns are applied in a cumulative fashion, we just keep applying more to filter down the data. 

This will be a short post, as today we are leading our second sold out Power Query workshop [Note: the live workshops have been replaced by Power Query Academy].  I wanted to make sure I still got something out for

A couple of weeks ago, Rudi asked how you would go about setting up a query to remove all rows up to a specific value.  Specifically, his question was this: The other day I was asked if Power Query could

I was working through a scenario today and came up against something unexpected when multiplying NULL values in Power Query. Background I have a fairly simple table of transactions that looks like this: And wanted to turn it into this:

Last week I posted a technique to show how to calculate a rolling 12 months in Power Query.  One of the techniques used was to refer to other steps during the construction of that query.  Shortly after publishing that, a

Last week, in a blog comment, a reader asked how to filter their data to only show the most recent rolling 12 month period.  This post looks at how I made that work in Power Query. Background Assume we have

At last, the Power Query update I’ve been waiting for has finally landed in the download site.  This is version 2.24, and sets my parameter tables technique back to a working state! You can download version 2.24 direct from Microsoft’s