Create Time Dimension

Stefan Johansson

AppSource 評分(11 AppSource 評分)

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


  • 可以變更您的文件或建議文件中需要變更之處
  • 可以在網際網路上傳送資料