Examples

The following formula returns a table with dates between January 1st, 2005 and December 31st, 2015.

CALENDAR (
    DATE ( 2005, 1, 1 ), 
    DATE ( 2015, 12, 31 )
)

The following expression returns the date table covering the range of dates in actual sales data and future sales forecasts.

CALENDAR (
    DATE ( YEAR ( MIN ( Sales[Date] ) ), 1, 1 ),
    DATE ( YEAR ( MAX ( Forecast[Date] ) ), 12, 31 )
)

Because a date column can be represented as an integer, CALENDAR can be used as a way to obtain a result similar to a particular call to GENERATESERIES. For example, the following expressions are equivalent, even if the former produces a table with a DateTime data type, whereas the latter returns a table with an Integer data type.

CALENDAR ( 1, 100 )

GENERATESERIES ( 1, 100, 1 )

-- CALENDAR requires to specify the boundaries, it returns a table with
-- one column (Date) including all the dates between the boundaries (included)
EVALUATE 
    CALENDAR (
        DATE ( 2022, 11, 26 ),
        DATE ( 2022, 12, 5 )
    )
ORDER BY [Date] DESC