Power Pivot Principles: Multiple Table Management
17 July 2018
Welcome back to our Power Pivot blog. Today, we discuss managing multiple tables.
As we’ve been going through this series of Power Pivot blogs, we’ve been creating measures predominantly in the ‘Sales’ table. If we look at this table in the Power Pivot window, we see that the measures are located at the bottom of each table in the ‘Data View’ mode.
If this table is deleted, intentionally or unintentionally, all of the measures contained within the table will also be lost.
A countermeasure that one may take is to create a completely blank table in the data set, which will house all of the measures. This will allow the user to add or remove tables without losing any of the measures in the data set.
It’s up to you which you do – just be consistent. At SumProduct, we acknowledge this approach but we prefer to house measures in the tables they are most closely associated with.
Stay tuned for our next post on Power Pivot in the Blog section. In the meantime, please remember we have training in Power Pivot which you can find out more about here. If you wish to catch up on past articles in the meantime, you can find all of our Past Power Pivot blogs here.