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