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