Passer au contenu principal

Create Time Dimension

Stefan Johansson

3.5 (11)

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
Fonctionnalités du complément
Lorsque ce complément est utilisé, il
  • Peut apporter des modifications à votre document ou en suggérer
  • Peut envoyer des données via Internet