topic Re: Calculated calendar table in Excel Power Pivot in DAX Commands and Tips

Calculated calendar table in Excel Power Pivot

DataNinja777 — Sun, 22 Oct 2023 12:11:53 GMT

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.

Re: Calculated calendar table in Excel Power Pivot

Greg_Deckler — Sun, 22 Oct 2023 13:07:46 GMT

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.

Re: Calculated calendar table in Excel Power Pivot

DataNinja777 — Sun, 22 Oct 2023 22:40:06 GMT

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.

Re: Calculated calendar table in Excel Power Pivot

Greg_Deckler — Mon, 23 Oct 2023 13:31:35 GMT

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

Re: Calculated calendar table in Excel Power Pivot

DataNinja777 — Mon, 23 Oct 2023 15:21:36 GMT

Thanks a lot Greg_Deckler !