Creating Rolling Periods Dimension in PowerPivot or Tabular models

If you created trend reports in Power View and then created some more and then when the next month came you cursed at yourself for being so prolific, then you will really benefit from the latest article I co-authored with Derek Daniels: Benefits of Dynamic Rolling Twelve Month Dimension in Tabular Models. The article talks about how you can have fully automatic update of the rolling periods (i.e., no manual update steps). Derek is the primary author of this really cool time saving concept.

This entry was posted in Computers and Internet and tagged , , , . Bookmark the permalink.

One Response to Creating Rolling Periods Dimension in PowerPivot or Tabular models

  1. Travis Kubota says:

    Hello. I just wanted to leave a special thank you to Sergei for helping us solve a difficult Excel issue when a file was corrupt. He was able to identify the reason for the corruption and we were able resolve the issue thereby saving us 2 days of work. Excellence! Thank you.

    Travis Kubota

Leave a Comment or Ask a Question

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s