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 is a special post to to discuss a suggestion to improve the Pivot Table experience, especially for Power Pivot users. This week I’m at the 2015 MVP Summit in Redmond, WA. It’s a trip I’m lucky enough to make
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.
