Calculated calendar table in Excel Power Pivot

[DataNinja777]

Hi,

I could not find calculated table icon in Excel Power Pivot.  Is it possible to create a calculated table calendar table in Excel?  Automatic calendar table was generated in Excel Power Pivot, but when the new dates are added, it is not updated automatically to include the newly added dates.  Please let me know how I can create a calculated calendar table in Excel Power Pivot which will expand the date range depending on the dates in the facts table. 

Thank you.

[DataNinja777]

Thanks a lot @Greg_Deckler !

[Greg_Deckler]

@DataNinja777 As far as I am aware, you can't do that in Excel still. You can only use DAX to create measures and calculated columns.

[DataNinja777]

Thanks @Greg_Deckler for the insight.  

An automatic calendar table has been generated in Excel implicit from the date range in the original fact table, but it is not getting updated for the increased date range in the fact table.  What can I do to expand the date range in the automatic calendar table generated by Excel?  As there is no formula referencing the date range, it seems that I cannot do anything to expand the range.  

[Greg_Deckler · Accepted solution]

@DataNinja777 You should be able to go into PowerPivot, click on the Design tab and then under Date Table select Update Range