Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
89
Views
Topic starter
Hi,
I am using Excel 2013, when Adding Excel Table to Power Pivot Data Model, how can I filter out unwanted columns on PowerPivot windows to make the data model compact ? I did not see the button to delete unwanted columns in PowerPivot "Manage" window.
thanks in advance.
Posted : 23/12/2018 7:58 am
Hi Yan,
You should use Power Query to get and shape/filter your data before loading it to Power Pivot. I recommend you complete the Power Query course first, then Power Pivot.
Mynda
Posted : 23/12/2018 7:25 pm
