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
If you’re on Office 365 and don’t have Excel’s new Rich Data Types, you should know that they’ll be coming to you soon. Giving us the ability to create both Stocks and Geographies, these are going to add some exciting
Did you know Power Query can be used as a task tracking tool? This might sound quite unusual but the method described here has been used for solving a real business case. The example I will use is rather simplified
At long last, we have confirmation that the Cache Shared Nodes Fix is live in Excel. If you're not familiar with this issue, it's one of the most important changes implemented in Power Query in quite some time. You can
Yesterday, I posted a new Power Query Challenge, and in this post I'm going to show my solution to challenge 4. You can pick up this solution as well as solutions created by the community in this thread of the
It's time for Power Query Challenge 4! This one is a tricky little challenge with creating a header row - but from different rows in the data set. The real world scenario driving Power Query Challenge 4 Have you ever
Whether by email or in person at conferences, I've received a lot of requests for more Power Query Challenges. You all seem to love testing your skills, and I really want to keep the Power Query Challenges going. In order
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
