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
TERMS OF SERVICE General This site, excelguru.ca, and all its sub-areas (“Website”) is owned and operated Excelguru Consulting Inc. Excelguru makes no representation or warranty that the information displayed on the website is appropriate or available for use in other
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
Yes, you read that right… Power Pivot is coming to all Office SKUs and the rollout has already started for those on subscription versions of Office. This is something I've been championing (along with many others) since Power Pivot was
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
I can't believe that it's less than a month until I'll be at the Amsterdam Excel Summit. We've got a full day of conference sessions on June 7, but the really cool part is that I get to teach Master
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
