Basic Explicit Measures

Article Overview One of the cool features in Power BI is ‘Quick Measures’, which allow you to quickly build up some DAX measures that might be challenging for a newer user. The one that that has always bothered us, however, is that it doesn’t provide an easy-to-use interface to build those basic explicit measure building […]

TimeSleuth

Article Overview One of the realities of building complex models is that we build models which take a long time to refresh. While timing with a stopwatch is easy, working with complicated query chains makes things harder, as your stopwatch can only time the global refresh. Have you ever wanted to: Time all queries in […]

QuerySleuth

Article Overview Query Sleuth is one of our smartest Monkeys.  Not only does it allow you to review, edit and indent the M code for any (and all) of your queries, it doesn’t lock you out of interacting with Excel like the Power Query Editor does. Another fantastic feature that this Monkey delivers is the […]

Destination Sleuth

Article Overview The DestinationSleuth is intended to solve two main issues with regards to working with Power Query in Excel: Help identify where a query has been loaded to Change multiple query load destinations at once In this article, we’ll explore exactly what this Sleuth does, as well as how to use it. Working with […]

SCD2 Monkey

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 – you can see exactly how this feature works as Ken demoed it for the Perth Excel meetup group. We’ve included a link to the recording below. […]

Calendar Monkey

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 feature […]

Add Measure Table

Article Overview Many modelers like to store their measures on a single “Measures” table in the data model.  If you’re one of them, you may appreciate the ability to quickly add a disconnected measure table into your data model for this purpose.  Thanks to the Measure Table Monkey, this is quite easy! In this article, […]

Table Monkey

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 – you can see how it works in a demo that Ken did for the KSA Excel Meetup group: https://youtu.be/FxwCtWN0uTs Share: Facebook Twitter LinkedIn Related Posts

SmartFolder Monkey

Article Overview One of our favourite tricks is to create a “From Folder” solution which avoids hard-coding a file path, instead pulling it dynamically via our fnGetParameter setup. The issue is that this creates a link to either a local or SharePoint / OneDrive for Business folder. However, this causes problems when you open the file in […]

Create Query from M Code

Article Overview One of the things that we do at Monkey Tools is help people with questions in forums. When someone provides us with an M code sample, it has always been a bit painful to get it set up: Create a new blank query, go to the Advanced Editor, paste in their code, save […]