Unpivot Stacked Sets with Inconsistent Rows
I'm currently hanging out in New Zealand, with a friend who has generously let me stay at his place instead of a hotel. What I didn't know when he offered a bed though, was that the cost of admission was
I'm currently hanging out in New Zealand, with a friend who has generously let me stay at his place instead of a hotel. What I didn't know when he offered a bed though, was that the cost of admission was
Recently I received a question on how to Unfill in Power Query. In other words, we want the opposite of the Fill feature, which fills data into blank cells (cells that contain a null value.) If we see repeating values,
I’m super excited to be presenting a Data Insights 2 Day Master Class in Wellington, NZ with my good friend Matt Allington. This is the first time we’ll be working together to bring our unique strengths to our participants in
Removing the top five rows from a data set is easy in Power Query, but what do you do when the number of rows changes? There isn’t a built-in Remove Dynamic Number of Top Rows function. In this post we’ll
"Microsoft Excel is not a spreadsheet application anymore, it’s a medium to store, present, and analyze data." - Puneet Gogia The way Excel has evolved in the past few years, it’s almost impossible to work without it in this present
If you've worked with Power Query in Power BI, you've seen Column Quality and Distribution features already. But I'm super exited to say that I've finally received it in the Insider build of Excel! What are the Column Quality and
One of the things that I find a bit misunderstood in Power Query is whether or not Data Types matter. I mean, I’m sure everyone agrees to some point that they do, but you do know just how much they
I'm super excited that Power Query Intellisense and Highlighting features are finally here in Excel! It's been a long time coming, with these features debuting in Power BI Desktop months ago. Where do Intellisense and Highlighting Show up? Let's look
Ken had a blast in June going down to Atlanta for the Microsoft Business Applications Summit (MBAS). There, he and co-author Miguel Escobar led an in-person workshop together for the first time. Ken also presented a breakout session on best
This week Ken is at the Microsoft Business Applications Summit in Atlanta. However, we're super excited that he'll be back on home turf in July for our next public training session. The 3-day Self Service BI Boot Camp in Vancouver
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.