Power Query Recipes Now Available
As you may have heard, we have been working on a set of helpful Power Query Recipes for Excel and Power BI and are excited to announce that they are now officially available! Are our Power Query Recipes for you?
As you may have heard, we have been working on a set of helpful Power Query Recipes for Excel and Power BI and are excited to announce that they are now officially available! Are our Power Query Recipes for you?
When Ken was at the Microsoft Business Applications Summit a few weeks ago, he met Mr. J.A. Garcia who has been doing some amazing work with Power Query. We wanted to share his story about how he has been using
Miguel and I were at the Microsoft Business Applications Summit last week, and we were frequently asked for an update on the Master Your Data book (aka M is for Data Monkey version 2.0). We were told that it’s time.
It's been a long time coming, but we are putting the finishing touches on the third installment of our free 'DIY BI' series. Consequently, we are excited to announce that the Power Pivot eBook will be officially released on Tuesday,
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
Unlock Excel Returns to Australia and New Zealand We're really excited that Ken is going to be heading back "down under" this April for CPA Australia's Unlock Excel conference. Spending two days in each of four different cities, Unlock Excel
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,
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.