Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

AndreasK115852429

Copper Contributor

Jul 16, 2022

Solved

PowerPivot Import new dates in caledar table

Hi guys, I am trying to import new dates in the calendar table in a powerpivot. Data ends to 31.12.2021 and need to expand todate Does anyone have a clue?

excel

Riny_van_Eekelen
Jul 16, 2022
AndreasK115852429 On the Design tab, click Date Table and then Update range (..........).

Riny_van_Eekelen

Platinum Contributor

Jul 16, 2022

AndreasK115852429 On the Design tab, click Date Table and then Update range (..........).

AndreasK115852429

Copper Contributor

Jul 16, 2022

Riny_van_Eekelen Thanks a million! It worked perfectly!