Hashiru Newland
New Contributor

Hello, how can I use CALENDARAUTO in the Excel Power Pivot window to generate a date table.

4 Replies



You don't need to use Calendarauto. In the PowerPivot window, click the Design ribbon and then Date Table > New.  That will create a date table from the first year to the last year of the data in your model. 



Thanks Ingeborg, I am preparing for 70-779 Analyzing and Visualizing Data with Excel, and CALENDAR AND CALENDARAUTO are part of the Excel Power Pivot Help. I was just trying to confirm, if this is possible and I have been using the Design ribbon Date Table > New command. I will now assume you can only use this in Power BI and maybe other applications that use DAX (e.g. SQL).

AFAIK, PowerPivot for Excel does not allow creating a new table the way that Power BI does. The CalendarAuto formula is still available in DAX for PowerPivot, because it returns a table of values. That resulting table can be used nested in other DAX formulas to create calculations and measures.


Thank for the clarification

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies