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
One of my favourite tricks to use on a dashboard is to show the Last Refreshed Date. This is important as it lets you know how stale your data is. I think it’s even more important with Power BI, as
This week’s post was inspired by a question in my Power Query help forum. The poster has a set up data, and needs to keep the most recent entry for each person from a list of data. Background I never
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,
Hey everyone, we need your votes to make a difference in Power Query and Power Pivot! There are a couple of items in the uservoice forums that I’d like to bring your attention to, and hopefully entice you to vote
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
