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
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
One of the big issues when distributing Power BI files locally is that the file paths get hard coded, and there is no way to make the path dynamic. This is very frustrating as any user who has a different
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
Excelguru Privacy Policy 1. What information do we collect and what do we do with it? We collect the personal information you give us, including your name and email address, as part of the registration process when you subscribe to
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
