Power Query Challenge 3
**Please note that the challenge is now closed, so we are no longer accepting submissions. However, you are still welcome to try it out on your own. I've got a lot of feedback that you enjoy the Power Query Challenge
**Please note that the challenge is now closed, so we are no longer accepting submissions. However, you are still welcome to try it out on your own. I've got a lot of feedback that you enjoy the Power Query Challenge
Sign up to receive the monthly(ish) Excelguru newsletter, featuring the latest updates for Excel and Power BI, upcoming training sessions, new products, and other information. As a "thank you" for subscribing, we are excited to share our FREE eBook series,
What an overwhelming response to Power Query Challenge #2! We had 40 submissions, and some with multiple entries in a single submission. Plainly you all enjoyed this! Naturally, there were a couple of submissions that involved custom functions, and a
Miguel and I were at the Microsoft Business Applications Summit last week, and we were frequently asked for an update on the Master Your Data book (aka M is for (Data) Monkey version 2.0). We were told that it’s time.
I'm at the Microsoft Business Application Summit this week, so I thought I'd post another Power Query challenge, especially since our last one was so successful. For this Power Query challenge … Our business challenge here is that we are
Installing Power Query The Power Query add-on is installed by default in Excel 2016 and can be found in the Get & Transform section of the Data tab. However, for Excel 2010 and 2013, the add-on needs to be downloaded
After one of my previous sorting posts, Devin asked if we can number rows by group. Actually, that's a paraphrase… what he really asked was: Any thoughts on how to produce something like a ROW_NUMBER function with PARTITION from T-SQL?
Slobodan emailed me to describe a trick to protect Excel tables that he is using to drive data validation lists. The data validation lists are sourced from tables loaded via Power Query, and leverage a little hack to hide them
Some time ago we embarked on a bit of a crusade to get Microsoft to fix a specific issue with Power Query related to performance. I posted about it in detail on the Power Pivot Pro blog, and have been
My recent post on showing the Top X with Ties inspired a discussion on ranking methods. Where I was looking to rank using what I now know as a standard competition rank, Daniil chose to use a dense ranking method
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
