This post illustrates a cool technique that I learned at the MVP summit last week, allowing us to use Power Query to merge multiple files with properties from the file in the output. A specific example of where this is useful is
The timing for the release of the October Power Query update couldn’t really have been much better for me, especially since it’s got a cool new feature in that you can now name columns during a merge. Why is this
I recently built a cool Excel solution at work that uses Power Query to reach out and grab some weather data, then upload it into database. We use that data in our dashboards, as weather is pretty important to the
When I’ve finished building a solution in Excel, I like to give it a little polish, and really make it easy for my users to update it. The last thing I want to do is to send them right clicking
In my last post, I looked at how to pull a named range into Power Query and turn it into a table of data. Today we’re going to look at how to create dynamic table headers with Power Query, but
One of the methods we use when building business solutions is creating specific input sheets for our models, as it separates our data from our business logic and ultimately our reporting layers. This strategy is a key piece of building
The comments of my last post collected a tip that I thought it was worth exploring on pulling Excel named ranges into Power Query. I made the claim that Excel MUST have the data in an official Excel table. As
My last few posts have been relatively technical, so this time I figured I’d look at something practical. I can’t believe it’s been almost a year since I blogged about un-pivoting data in Power Query, so it’s about time we
The other day I asked one of my co-workers how many ways he knew of to round a number. His answer was one… if it ends in .4 it rounds down and if it ends in .5 it rounds up.
The August update for Power Query was finally made available on Sept 1, and it has some pretty cool stuff in it. In this week’s segment I thought we’d cover off one of the features that I’m most excited about
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
