CALENDAR DAX Function

The CALENDAR DAX function returns a table with a single column named "Date" that contains a continuous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.

DAX Syntax CALENDAR(start_date, end_date)

Example: Create a table named “New Calendar Table” with one column named “Date” that contains the dates in between the start and end date, both dates are inclusive in the returned result.

DAX

New Calendar Table = CALENDAR("01-03-2024", "5-07-2026")
CALENDAR dax function