![]() 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 calculated columns: Creates a static list of all the calculated columns that exist 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.Įach calculated column is listed with its DAX expression and with the name of the table it belongs to.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.Credits: Kasper De Jonge, Scott Senkeresty. ![]() NOTE: this feature works in Excel without requiring Analysis Services and provide a quick summary of the size of each column. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |