Skip to main content

Create Time Dimension

Stefan Johansson
Enables easy creation of a day based Time Dimension table for analysis in PowerPivot

Create Time Dimension creates a table with the required information for a time dimension. The time dimension table can be used for analysis of information in one or more data tables so that the plain date information from the source data can be broken down by year, month, quarter etc.

Once the table is inserted into the spreadsheet it can be expanded with any custom columns directly in the spreadsheet using Excel 2013 formulas or added to a data model in PowerPivot and extended using DAX.

This app solves the problem of manually creating or linking Time Dimension information every time a Time based table is needed. By choosing the needed start and end date the number of day rows can be customized for individual analysis needs

The table is day based and includes columns for:

  • Year

  • Month
  • Day
  • id
  • Quarter
  • Day Names
  • Month Names
  • Day of Year
  • Day of Week
Add-in capabilities
When this add-in is used, it
  • Can make or suggest changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/product/42949674051/e64421d0-9284-45a6-b11e-4272223bf5d1/after512.png
    https://az158878.vo.msecnd.net/marketing/product/42949674051/e64421d0-9284-45a6-b11e-4272223bf5d1/after512.png
    https://az158878.vo.msecnd.net/marketing/product/42949674051/61edf53b-cf83-49c8-b25b-2b495023475e/before512.png