Create a separate related time table for time intelligent functions in PowerPivot

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

To make use of Time intelligent functions in PowerPivot it is recommended to create a separate related time table. This will make sure you don’t need all kind of tricks to make sure you have date, check out this blog post to see why we need a related time table in more detail. This blog post will describe how to create a separate related time table, the easy way.

Read more...

 

Tags: excel, time

 

2007-2015 VidasSoft Systems Inc.