CALENDAR Function (DAX)
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 the specified end date, inclusive of those two dates.
CALENDAR Formula Syntax
CALENDAR(
<start_date>, <end_date>
)
How do you use the CALENDAR function?
Calendar functions manipulate data of the data types DATE and DATETIME based on a calendar year.
Related Blog Posts
Related Support Forum Posts
Understanding DAX Formula
Developing Complex Dax functions
Considerations when using the CALENDAR function
An error is returned if start_date is greater than 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]))
CALENDAR ( DATE ( 2005, 1, 1 ), DATE ( 2015, 12, 31 ) )
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.
