PowerPivot Import new dates in caledar table

Copper Contributor

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?

2 Replies
best response confirmed by Hans Vogelaar (MVP)

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



@Riny_van_Eekelen Thanks a million! It worked perfectly!