Blogs from Wise Owl on Calendar in PowerPivot 2010

Creating a PowerPivot calendar in Access or Excel

Posted by Andy Brown on 16 January 2013

This blog shows you how to create a calendar of dates for use in PowerPivot. Instructions are included for Excel and Access.

Create a calendar table for PowerPivot or Analysis Services in SQL Server

Posted by Andy Brown on 04 January 2013

This blog includes the SQL script to generate a table of calendar dates for linking to from within PowerPivot or an Analysis Services tabular model.