Category: Excel

One of the questions I get quite frequently is how we can pass parameters to SQL queries, allowing us to make them dynamic. Someone asked a question in the forum on the topic, so that finally inspired me to write

Well, there’s good news and bad this time.  I just updated my Excel 2016 to 16.0.6868.2048 (First release version) and there is a fix and a new bug evident. First, the fix As I reported a couple of weeks ago,

The April 2016 Power Query Update was just released for Office 365 subscribers, and I can confirm that it is available to the First Release customers, as I’ve already got it installed.  (If you’re on a later branch it may

I got an email from a friend today who was using some complicated logic to replace specific records in a table with records from another table.  His query was running pretty slow, so he reached out for a little help.

A while back I got an email from someone who had taken my Power Query course online.  They were asking how to create a running total, although with some added twists and turns for calculating taxable gains and losses for

I got a question on the blog recently about creating a banding function in Power Query, or creating buckets for Accounts Receivable transactions (30-60 days, 60-90 days, etc.).  As this is something that can be applied to a lot of

This post solves a tricky issue of removing offset duplicates or, in other words, removing items from a list that exist not only in a different column, but also on different rows. Problem History This data format is based on

Without question, the Expand feature that shows up when you are merging tables using Power Query is very useful.  But one of the things I’ve never called out is that – when you are merging tables – you have the