July 2016 Power Query Update
Hey folks, I'm actually on vacation, so this post is going to be short. I just wanted to make sure you all are aware that there is a new Power Query update available. New features in the July 2016 Power
Hey folks, I'm actually on vacation, so this post is going to be short. I just wanted to make sure you all are aware that there is a new Power Query update available. New features in the July 2016 Power
Yesterday, Microsoft released the June 2016 Power Query update. Even though there are only four items on the list of new features, some of them are quite impactful. What’s new in the June 2016 Power Query Update The four new
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'm honestly not sure what's taken me so long to do this, but I'm pleased to say that I've finally added a Power Query specific help forum at Excelguru. I'm hoping that this forum becomes THE place to ask and answer
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.
I know that this comes with limited notice but… as many of you know I'm currently in Sydney, Australia, and I'll be in Melbourne in a couple of days for Excel Summit South. Well, as it happens, I'm actually staying
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
The intake is closing soon for our first Power Query class of 2016, which starts on February 3, 2016. If you haven't heard about this, or you've been considering taking it but haven't signed up yet, you've been missing out.
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.