Name Columns During a Merge
The timing for the release of the October Power Query update couldn’t really have been much better for me, especially since it’s got a cool new feature in that you can now name columns during a merge. Why is this
The timing for the release of the October Power Query update couldn’t really have been much better for me, especially since it’s got a cool new feature in that you can now name columns during a merge. Why is this
Today I’m working on building a new reporting system at my day job. Basically we’re looking at creating tools to budget and forecast results to be reviewed weekly, with a goal of being more on top of results so we
Several years ago, when Power Pivot first hit the scene, I was talking to a buddy of mine about it. The conversation went something like this: My Friend: “Ken, I’d love to use PowerPivot, but you don’t understand the database
We’re pleased to announce the first Monkey Tools update is now available for download! This one contains a new feature, some new logic and an update to one of our data connectors. Read on for more information! I can’t believe
Will Thompson from the Power BI team threw out a question on Twitter today related to Appending Columns with Different Names: Let's say I have some CSVs coming in where the column names differ from file to file, but always
We are super excited to announce that we’ve (at last) released the first version of our Monkey Tools software! Ken has been working on this software on and off for the better part of 8 years now. But after showing
Sign up to receive the monthly(ish) Excelguru newsletter, featuring the latest updates for Excel and Power BI, upcoming training sessions, new products, and other information. As a "thank you" for subscribing, we are excited to share our FREE eBook series,
Introduction: One of the biggest parts lacking in user constructed solutions is documentation in the form of help files. As coders, we usually find it easier to build the application than explain to someone how to use it properly. After
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.