Use Dynamic Ranges in Power Query
This was a great question that came up in my M is for (Data) Monkey session at the Amsterdam Excel summit: Can we use dynamic ranges in Power Query? If I recall correctly, this was asked by Gašper Kamenšek, after
This was a great question that came up in my M is for (Data) Monkey session at the Amsterdam Excel summit: Can we use dynamic ranges in Power Query? If I recall correctly, this was asked by Gašper Kamenšek, after
I was presented with an interesting problem last week: how to create running totals in Power Query. There doesn’t appear to be a built in method to do this, so I thought it would make an interesting use case study.
I got a comment on my blog the other day from David, asking if we could make Power Query prompt for a folder at refresh, allowing us to choose which folder to should be used to consolidate files. That sounds
I got sent this today from a friend. He was a bit frustrated, as he got a message from Power Query that read “Formula.Firewall: Query 'QueryName' (step 'StepName') references other queries or steps and so may not directly access a
I’ve posted on consolidating worksheets before, but in a task I got asked to do last week, I took a slightly different approach. This approach allows consolidating worksheet print areas to grab the data that I need. Background In the previous post,
I got a comment on a previous post today, which made me realize I’d promised this but never posted it. So let’s look at how to combine multiple workbooks together in Power Query, providing they have the same format. Yes,
Some time ago I posted a technique to pass parameters to Power Query via an Excel table. In a comment on that post, Anand asked “Can I pass the parameter to a SQL Table as well?” The question could mean
I was chatting with my friend Scott of www.tinylizard.com today, discussing the structure of the M language, and how it’s kind of weird compared to VBA, C# and such. Well, “what the #?”, I figure. I’m going to do a
Date formats in Power Query are one of those little issues that drives me nuts… you have a query of different information in Power Query, at least one of the columns of which is a date. But when you complete
Tonight I decided to actually follow through on something I’d been musing about for a while: building a full fledged VLOOKUP function in Power Query. Why? Yeah… that’s probably a good question! Replicating VLOOKUP’s exact match is REALLY easy in
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
