CALENDAR

CALENDAR 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.


Syntax

CALENDAR(start_date, end_date)

Parameters

start_date Any DAX expression that returns a datetime value.

end_date Any DAX expression that returns a datetime value.

Return Value

Returns a table with a single column named “Date” containing 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.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Date and Time Functions / CALENDAR