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
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
How you protect power queries is a question that will come up after you've built a solution that relies heavily on Power Query, especially if you're going to release it to other users. (This is a quick post, as I'm
Today I wanted to just make a quick announcement that we are currently working on a series of free 'DIY BI' e-Books. Free 'DIY BI' e-Books? Tell me more! Over the past few years of working with Excel an Power
This week's blog post on solving business problems with Power Query is a guest post by Alex Jankowski Does your business or work group have manual tasks that are repeated regularly, such as data re-entry, copy/paste functions, sending the same old email,
Have you ever set up a nice query to UnPivot other columns, only to find that the query data types change when you add new columns? This post will cover why values become text after unpivoting other columns. Background We’ve
We're back with post two of Miguel's week. This time, he is going to take his previous solution and show us how versatile Power Query can be, leveraging code he's already written and Making Transformations Re-Usable. Have at it, Miguel! Making Transformations Re-Usable In
This week we've got a guest post from Miguel Escobar, who is going to tell us why transforming data with Power Query is his first preference versus other tools and methods. In fact, this is part 1 of 2, and
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
