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
Last week I got an email from one of our readers, with some feedback related to how Monkey Tools’ PivotSleuth works with Measure tables in Power Pivot. Best practices is to set up a disconnected table to house DAX measures.
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
I'm currently hanging out in New Zealand, with a friend who has generously let me stay at his place instead of a hotel. What I didn't know when he offered a bed though, was that the cost of admission was
Monkey Tools Add-in Monkey Tools is an Excel add-in containing a set of tools to help you build better data models more quickly and using data modelling best practices. They also help you audit what has been done in your
Recently I received a question on how to Unfill in Power Query. In other words, we want the opposite of the Fill feature, which fills data into blank cells (cells that contain a null value.) If we see repeating values,
Removing the top five rows from a data set is easy in Power Query, but what do you do when the number of rows changes? There isn’t a built-in Remove Dynamic Number of Top Rows function. In this post we’ll
"Microsoft Excel is not a spreadsheet application anymore, it’s a medium to store, present, and analyze data." - Puneet Gogia The way Excel has evolved in the past few years, it’s almost impossible to work without it in this present
On this blog, I showcase a lot of different techniques for manipulating and reshaping data. For anyone that follows the blog, you already know this, and you know it's a pretty important topic to me. But the thing we shouldn't
If you've worked with Power Query in Power BI, you've seen Column Quality and Distribution features already. But I'm super exited to say that I've finally received it in the Insider build of Excel! What are the Column Quality and
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
