Forum Discussion
CALENDARAUTO
Hello, how can I use CALENDARAUTO in the Excel Power Pivot window to generate a date table.
Hello,
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.
pls I don't know why my Date Table is only giving me default option in the Power Pivot. any help pls?