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

Create Time Dimension

by Stefan Johansson