Feb 01 2019
06:31 PM
- last edited on
Jul 12 2019
11:19 AM
by
TechCommunityAP
Feb 01 2019
06:31 PM
- last edited on
Jul 12 2019
11:19 AM
by
TechCommunityAP
Hello, how can I use CALENDARAUTO in the Excel Power Pivot window to generate a date table.
Feb 03 2019 12:17 PM
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.
Feb 05 2019 07:55 AM
Feb 05 2019 09:49 PM
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.
Nov 21 2023 04:47 PM
Nov 21 2023 05:39 PM
Nov 21 2023 05:56 PM