Option to automatically check for add-in updates at startup.Option to extract and format measures and calculated columns DAX expressions in a single step.Description field now added to the list of calculated columns.Removed errors formatting a large number of DAX expressions (now it splits a large request in smaller batches).History of older versions (no longer available online) v1.0.8 You will find a more detailed documentation of other contextual menu features in the help file included in the ZIP. By default, it is available in the Add-ins ribbon. Dax Studio: Opens DAX Studio without having to open another ribbon.
It requires an active Internet connection. Typically, you can use this button after you have created tables either with the “List calculated columns” or “List measures” buttons. You must select a cell in a table that contains a ‘DAX Expression’ column and the whole column will be formatted. Format DAX expressions: Uses to create nicely formatted DAX expressions.You can obtain more detailed information with VertiPaq Analyzer, but you need to restore a Power Pivot model in Analysis Services in order to use it. NOTE: this feature works in Excel without requiring Analysis Services and provide a quick summary of the size of each column. Credits: Kasper De Jonge, Scott Senkeresty. Model memory usage: Creates a table that analyses the size of each column that exists in the Power Pivot data model of the active workbook.List unused columns: Creates a static list of all the columns that exist the Power Pivot data model of the active workbook, highlighting those that are not used and providing info about where the others are used.Each calculated column is listed with its DAX expression and with the name of the table it belongs to. List calculated columns: Creates a static list of all the calculated columns that exist the Power Pivot data model of the active workbook.The macro adds a “level” column to the table which displays the distance with the selected measure, and then filters the table to only show the related measures. List Dependents and Precedents Measures: After all measures of a data model have been listed with the “List measures” command, you can click a measure name in the table and press on one of the buttons in the ribbon (Dependents or Precedents in the Measures section). The measure dependencies are then analyzed recursively.Each measure is listed with its DAX expression and with the name of the table which it belongs to. List measures: Creates a static list of all the measures that exist in the Power Pivot data model of the active workbook.
If you modify the relationships after creating the table, you can invoke the macro again and the existing table will be overwritten after user confirmation. The list is created in a new worksheet named “Model_Relationships”.