DAX Function Guide

CALENDAR
Empty image or helper icon

Sam McKay

CEO & Founder

How does the CALENDAR 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?

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

Related Blog Posts

Loading

Considerations when using the CALENDAR?

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

Related Video Tutorials

Loading

Formula examples using the CALENDAR

=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 Courses

Loading