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
In my last post, we looked at creating an IF statement using Power Query. This time we’re going to go a bit deeper and look at multi condition logic in Power Query, exploring a scenario where we need to choose between
In my last post I talked about useful text functions, and how they differed between Excel and Power Query. Today we’re going to look at another compare/contrast scenario, but this time it’s going to be the IF function in Power
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
