Yesterday, Nick (one of our forum users) posted a Phone Words challenge in our forum, which looks like a great candidate for Power Query Challenge #7. I haven't had time to tackle it myself, but if you're up for a
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
This morning I logged in to check the solutions for Power Query Challenge 6 that were submitted and... Wow! There were a bunch, and some cool variety there. So now it's time to show you all what I came up
Are you ready for Power Query Challenge 6? In this challenge we'll look at splitting nested data sets into a nice table in First Normal Form. Let's take a look at Power Query Challenge 6: Where did the challenge come
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
Hopefully you’ve had a chance to try and build a solution to Power Query Challenge 5. In this thread, I’ll show you how I approached it. Challenge Goals The challenge in this case was to allocate a fixed amount for
It’s been a while since our last challenge, so hopefully you’re ready for Power Query Challenge 5! This is one that came up as I was teaching one of our 3 day Excel BI Bootcamp courses for a client, (similar
Sometimes, what should be easy code to write has unexpected pitfalls resulting in opportunities for new learning. I needed to generate a one or two-tiered stream of date values with multi-frequency period cycles, monthly vs annual. For example, after installing
A recent question from one of our Power Query Academy registrants was about creating a fiscal Saturday calendar - or a calendar where periods end on the last Saturday of each month. I cooked up a sample of one way
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
