Monkey Tools

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

Click Query Monkeys -> Measure Table Monkey to 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

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

Create Query from M Code

Coming Soon! Sorry, but this article isn’t quite ready yet. We promise that we’re working on it! Share: Facebook Twitter LinkedIn Related Posts

Smart Folder Function

Article Overview If you save your files into folders that sync to OneDrive for Business or SharePoint, you’ll know the pain that happens if you try to reference a folder based on the path returned by the CELL() function… The SmartFolder function provides the answer to that problem, as you can pass it either a […]

Get ISO Week Function

Article Overview We heard from some of our European friends that they are not fans of the North American week numbering systems. While Power Query has a “week number” function, it does not contain any functions to get ISO weeks. Our answer to this was to add an easy-to-use Monkey who will inject a GetISOWeek […]

Get Month Ends Function

Launching the Get Month Ends function from the Query Monkeys menu

Article Overview A common task for financial professionals is allocating payments over multiple days or months. In fact, if you’ve read Chapter 18 of Master Your Data with Excel and Power BI, you’ll see that the creation of a function called fnGetMonthEnds is essential in some of the recipes. Of course, you can always do […]

Parameter Table and Function

Article Overview If you’re a fan of the fnGetParameter function (as per Chapter 17 of my Master Your Data book), you’ll love this Monkey. With just a click, it will insert the Parameter Table and fnGetParameter function into your workbook.  It even places the Excel File Path formula in the cell for you! In this article, we’ll explore exactly […]