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
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
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
I was playing around with a scenario this morning where I was adding try results together in order to count how many columns were filled with information. What I needed to do kind of surprised me a little bit. The
This post is a guest article from Marcus Croucher, a finance professional based in Auckland, New Zealand. Marcus instantly fell in love with Power Query after seeing how it can easily transform data in ways Excel finds difficult, and how
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
