Ok why should i want to load an entire time table in PowerPivot ?

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Ok remember the Time intelligent function golden rules ? One of the key items there is :

  • Always create a separate Time table.

And why is that you think? Well i got a question about someone doing a previous year but got only values until the current month he has data, like this:

Read more...

 

Tags: excel, time

 

2007-2015 VidasSoft Systems Inc.