Aggregate Data While Expanding Columns
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
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
Even though this hits on techniques used on this blog before, a colleague asked today “I have a lot of garbage names in a column and only want to keep rows that begin with an alphabetical character.” I figured we’d
As it’s the beginning of a new year, I thought it might be interesting to show my spin on creating a custom calendar in Power Query. This topic has been covered by many others, but I’ve never put my own
Last week’s blog post on merging tables using Outer joins has proved to be pretty popular. (I guess I’m not the only one who struggled with this concept!) This week we’ll look at the remaining three options, showing how to
The term “Join” comes from the database world, and I’ll admit that I’ve struggled with understanding it... especially when you combine it with some other keywords. So this week I thought it would be good to explore it in a
Some time ago I got an email from Alex asking me if there was a way to identify duplicates using Power Query, but without removing non-duplicate records in the process. This post explores how to do that. Background Suppose someone
In this week’s post we’re going to circle back to the original post on how to Separate Values and Text in Power Query from November 4, 2015. That post attracted a couple of suggestions from Imke Feldman and Bill Szysz
My last blog post was interesting in that I got a few emails about it. Both Imke Feldman and Bill Szysz sent me better methods, and a blog commenter asked for a slightly different version. For this post, I’m going
I recently received a comment on one of my blog posts asking how to separate values and text, especially when there is no common delimiter such as a space separating them. This is a bit of an interesting one, as
This past weekend I attended SQL Saturday in Portland, OR. While I was there, I attended Reza Rad’s session on Advanced Data Transformations with Power Query. During that session, Reza showed a cool trick to merge data based on two
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
