Forum Discussion
to POWER PIVOT or not ???
Hi I Would very much appreciate your views on my what my next step is to avoid my SLOW standard pivot tables. i have ONE large source worksheet with 12000 rows and 5 columns of data. i have 6 pivo...
stever78 Well, PP can do all a regular PT can do, plus much more. Just try, I would say. And perhaps a good idea NOT to load the 12K rows data into the workbook, but connect to it via PowerQuery. There you can do some initial filtering and/or clean-up (if needed). Load the table to the Data Model and see if you can use measures rather than calculated columns.