Analysis of data over date ranges is one of the most common use cases for data analysis.  In this Video Chris Campbell demonstrates an easy method to create a date table in Microsoft Excel.  The resulting table can be exported to a SQL database, or used directly in a PowerPivot solution.

1 Comment

Comments are closed.