General Questions about Power Pivot

SuperNerd

New Member
Joined
Sep 16, 2020
Messages
37
Office Version
  1. 365
Platform
  1. Windows
I have some large datasets I need to manipulate with some more complex pivot tables (1.5mil rows in one table, 500k rows in another, etc). I know I need to use Power Pivot- but have some general questions about it...

The raw data requires me to look at every cell in multiple columns, and if the value is >0, then assign a new value of '1' to it (or '0' if it's <0). Is this something I do right after I import the data? Or do I do the basic import/transform stuff first, then import into a data model... then use formulas to assign new values, do some math calculations, etc on it then? Ultimately it will all end up in a series of pivot tables.

I guess my main confusion is where/when do I perform calculations/formulas on the data when using Power Pivot?

I've watched multiple videos- and they all do basic stuff upon importing (changing field types, # of decimals, etc). They never show doing any kind of more complex calculations/formulas to manipulate & use the data...

Can someone explain the basic concepts on this for me?
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,112,814
Messages
5,542,649
Members
410,566
Latest member
Jonniehoffman
Top