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
A couple of years ago, the Power Query team added Parameters as a proper object, but I kept on Creating Dynamic Parameters in Excel Power Query the same way as I always had. The reason for this is two-fold: the
This post on changing a single file query to a From Folder query is a guest article by John MacDougall, a Microsoft Excel MVP from Canada and owner of HowToExcel.org. Recently, I had to import a large-ish CSV file at
Last week I posted a Top X with Ties Challenge to see how our readers would approach this problem using Power Query in Excel or Power BI. I'm really glad I did this, and am thinking that I need to
Please note: the submission period for the Top x with Ties Challenge is now closed. You can check out the follow-up post where the results are summarized here. Yesterday I was working on a data set, and needed to work
In a comment on a previous post, a reader asked how you return a specific day of the next month from any given date. In other words, I've got a date of March 5 and I want to use Power
This is a cool example of how to Extract Data Based on the Previous Row, which came up as a viewer's question inside our Power Query Academy. Let's look at how we solved it… What Kind of Data Needs This
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
