Forum Discussion
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, 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 You should be able to go into PowerPivot, click on the Design tab and then under Date Table select Update Range
4 Replies
- DataNinja777
Thanks a lot Greg_Deckler !
- Greg_Deckler
Community Champion
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
DataNinja777 You should be able to go into PowerPivot, click on the Design tab and then under Date Table select Update Range
