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

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

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