Excel PowerPivot: CALENDAR Function (DAX)

Excel PowerPivot DAX Function & Features

CALENDAR Function (DAX)

Syntax:

CALENDAR(<start_date>, <end_date>)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.

Action:

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.