In Excel, we can easily create absolute and relative references. A simple $ symbol here and there is all it takes. But Power Query is less flexible, therefore getting values from other rows is not as simple. So, in this post, we cover how to get Power Query absolute and relative references. Download the example … Read more
A few days ago, a reader asked a question about using parameters in Power Query; they wanted to auto-refresh Power Query whenever a parameter changes. “One question, how do you set the query to refresh automatically when a value changes.” I’ve not tried this before, but I can understand the benefits. It reduces the need … Read more
In this post, I want to cover a common reporting requirement, which is a Power Query running total. I have previously covered a similar topic in a post about running totals in tables; however, those methods don’t work in Power Query. So, we’ll need to find an alternative approach. Both Tables and Power Query were … Read more
It’s now time to bring this Power Query series to a close. And where better place to end than with some tips and tricks to help you to succeed. Change the default Close & Load options Power Query’s default Close & Load options assume we want to load the data into an Excel table. As … Read more
As we continue through this Power Query series, we have now reached a common and frustrating data format; data stacked in a column. In this post, we will investigate one basic method for unstacking data. While the example we are looking at below would most likely be created by a person who didn’t know how … Read more
The web is a vast place with so much information. However, just because the data is there does not make it easy to get at In this post, we’ll look at how we can load web data into Power Query. While you might get excited at the thought of absorbing data from everywhere with the … Read more