Creating Calendar Table with Variables - Min Date Incorrect

[rliebau]

I am creating a Calculated Date table using Min and Max dates as the date range. Frequently I do this using dates from an imported table, but this time I manually entered the MinDate I want. No matter what I do the actual date range does not go past 1/1/2019. 

Here's my code:

Date = 
var MinDate = DATE(2014,1,1)
var MaxDate = EOMONTH(TODAY(),-1)
RETURN
ADDCOLUMNS(
    FILTER(
        CALENDARAUTO(),
        [Date]>= MinDate &&
        [Date]<= MaxDate
    ),
    "Year", YEAR([Date]),
    "Quarter Number", INT(FORMAT([Date], "q")),
    "Quater", "Q" & INT(FORMAT([Date], "q")),
    "Quarter Year", INT(FORMAT([Date],"q")) & "Q" & RIGHT(YEAR([Date]),2),
    "Month End", EOMONTH([Date],0))

It's clear that I want the variable MinDate to be equal to 1/1/2014, and I use the DATE() function to recognize that value as date.

Here are a few visuals of the Date table:

It only created a date table with 1/1/2019 as the earliest date. What am I missing?

[rliebau]

I fixed it. I forgot that CALENDARAUTO() relies on a base datetime column in an existing table. I had one table imported already that only had a date range in 2019.

Here's the corrected code for anyone interested:

Date = 
var MinDate = DATE(2014,1,1)
var MaxDate = EOMONTH(TODAY(),-1)
RETURN
ADDCOLUMNS(
    CALENDAR(MinDate, MaxDate),
    "Year", YEAR([Date]),
    "Quarter Number", INT(FORMAT([Date], "q")),
    "Quater", "Q" & INT(FORMAT([Date], "q")),
    "Quarter Year", INT(FORMAT([Date],"q")) & "Q" & RIGHT(YEAR([Date]),2),
    "Month End", EOMONTH([Date],0))

[AlB · Accepted solution]

Hi @rliebau 

Use CALENDAR instead of CALENDARAUTO:

Date =
VAR MinDate = DATE ( 2014, 1, 1 )
VAR MaxDate = EOMONTH ( TODAY (), -1 )
RETURN
    ADDCOLUMNS (
        CALENDAR ( MinDate, MaxDate ),
        "Year", YEAR ( [Date] ),
        "Quarter Number", INT ( FORMAT ( [Date], "q" ) ),
        "Quater", "Q" & INT ( FORMAT ( [Date], "q" ) ),
        "Quarter Year", INT ( FORMAT ( [Date], "q" ) ) & "Q"
            & RIGHT ( YEAR ( [Date] ), 2 ),
        "Month End", EOMONTH ( [Date], 0 )
    )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[rliebau]

@AlB Thanks. I figured it out but you just barely beat me to it!