Syntax
CALENDARAUTO([fiscal_year_end_month])
Remarks
Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is calculated automatically based on data in the model.
Tutorial with example
Create a calendar with DAX in Power BI. Generate/ Create calendars in DAX using CALENDAR() and/or CALENDARAUTO().
Video keynotes:
01:02 Calendarauto function
03:02 Calendar function

And a bonus item, a blog post on how to create all kinds of calendars:
https://curbal.com/blog/create-power-bi-custom-calendars
Download example file:
Link to Power BI file: here.
Was this helpful?
Leave a Reply