DAX Table Monkey

Article Overview While PivotTables and PivotCharts are a useful and valid way to summarize your data, sometimes you want a good old table. While it has been possible to do this with Power Pivot-backed data models since day 1 of Power Pivot, it has required some black magic and DAX knowledge to make it happen. […]

Modern Pivot Monkey

Article Overview The Modern Pivot Monkey’s goal is to help you quickly take a classic PivotTable and create an upgraded Data Model-backed PivotTable, opening the abilities to: Leverage the power of DAX measures. Perform source data filtering and cleansing via Power Query. Expand the data model’s logic, enhancing the analytic output. In this article, we’ll […]

From Table or Range Monkey

Article Overview One of the things we have been asking the Excel team to do for a long time is give us the ability to provide a table name during the creation process.  This is particularly important when using the Get Data From Table/Range feature, as this feature creates a generic table (or dynamic array) […]

Biblio Monkey

Article Overview If you’ve worked with Excel for any length of time, chances are pretty good that you have some favourite Power Queries, DAX Measures, VBA, or formulas. And if you are like many users, you store those in a Notepad document for easy copying and pasting. Biblio Monkey aims to change that for you, […]

Customize the Monkey Tools Tab

Why Customize the Monkey Tools Tab? The Monkey Tools ribbon was designed with one goal in mind – to make you more efficient when building queries and/or data models. A big part of that was building a central ribbon tab which would minimize tab-switching in order to get your job done.  But what if you […]

Submitting Error Logs

Process Overview The most likely reason you are at this page is because you have been directed here after logging a bug report, and we have requested an error log to nail down where our monkeys are messing about. While we wish you didn’t have to do this, we very much appreciate your willingness to […]

Installation and Activation Issues

Article Overview While we hope that Monkey Tools installs easily and keeps running, the reality is that software is a complicated thing, and sometimes things break. This article is intended to capture the most common issues that can occur, and provide solutions to get you (back) up and running as quickly as possible. This article […]

DMVSleuth

Coming Soon! Sorry, but this article isn’t quite ready yet. We promise that we’re working on it! In the mean time – until we get this article updated – there is some documentation on this feature in our legacy Install and Features Guide. Download our Legacy Install & Features Guide Finding this content… This Sleuth […]

ModelSleuth

Coming Soon! Sorry, but this article isn’t quite ready yet. We promise that we’re working on it! In the mean time – until we get this article updated – there is some documentation on this feature in our legacy Install and Features Guide. Download our Legacy Install & Features Guide Finding this content… You’ll find […]

DAXSleuth

Coming Soon! Sorry, but this article isn’t quite ready yet. We promise that we’re working on it! In the mean time – until we get this article updated – there is some documentation on this feature in our legacy Install and Features Guide. Download our Legacy Install & Features Guide Finding this content… You’ll find […]