Creating a Fiscal Saturday Calendar
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
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
In the good old days, it was easy to check the application version in Office with VBA. You just used a little test of Val(Application.Version) to return the number. 12 was Office 2007, 14 was Office 2010, 15 was Office
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
As 2018 draws to a close, I've been taking a look back and thought I'd share a quick Year in Review for the last 12 months at Excelguru. This is not by any means a complete look at things, but
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
As you may have heard, we have been working on a set of helpful Power Query Recipes for Excel and Power BI and are excited to announce that they are now officially available! Are our Power Query Recipes for you?
Wow… 46 submissions for Power Query Challenge 3! Crazy stuff. So many that I haven't even had time to read them all yet! Due to the overwhelming responses, here's how I'm going to handle this: Show you how I approached