How does the CALENDAR function (DAX) work?

The CALENDAR function (DAX) returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is from the specified start date to end date. 

CALENDAR Formula Syntax

CALENDAR(
     <start_date>, <end_date>
)

How do you use the CALENDAR function?

This Power BI function returns a date range defined by its two parameters: the start and end date.

Related Blog Posts

Related Support Forum Posts

Fiscal Year -> Calendar Year
Offset in CalendarTable
YTD Showing for Months after Last Sale

Considerations when using the CALENDAR function

An error is returned if the start date is greater than its end date. 

Related Video Tutorials

Formula examples using the CALENDAR function

=CALENDAR (DATE (2005, 1, 1), DATE (2015, 12, 31))

=CALENDAR (MINX (Sales, [Date]), MAXX (Forecast, [Date]))

Related Course Modules

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.