Forum Discussion
DataNinja777
Super User
Super UserCalculated calendar table in Excel Power Pivot
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...
DataNinja777 You should be able to go into PowerPivot, click on the Design tab and then under Date Table select Update Range
DataNinja777Super User
Super UserThanks 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
Community Champion
Community ChampionDataNinja777 You should be able to go into PowerPivot, click on the Design tab and then under Date Table select Update Range