Cross Join Three Tables via DAX Query to seed a Date Dimension.

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

This is a variation on an old SQL trick to seed a Date (aka Time) dimension. You'll need such a table in many, if not all, PowerPivot models as the proper functioning of Time Intelligence functions require a separate table containing a date column populated with a no-gaps sequence of dates covering the potential time span of the model.

Read more...

Tags: dax

 

2007-2015 VidasSoft Systems Inc.