I Need Beta Testers
Today’s post isn’t of a technical nature, although it does have a pretty long technical background… I’m now at the point where I need beta testers for a new add-in I’m planning to release. What Does the Add-in Do? In
Today’s post isn’t of a technical nature, although it does have a pretty long technical background… I’m now at the point where I need beta testers for a new add-in I’m planning to release. What Does the Add-in Do? In
While I was at the PASS BA conference in San Jose, CA last week, I got an email from a reader asking if Power Query could create a Cartesian Product join. Now I’m an Excel guy, and I’d never heard
Ken is at the PASS BA conference this week, so it seemed like a perfect time for me to publish my first Power Query post here. In this installment, I'm going to show how to map columns between data sets.
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
