Own date table is not properly filling itself out

[ThomasSan]

Hi everyone,

I am having the problem that my DAX command for creating a date table is not properly working. I am using the following DAX formula:

Date = 
VAR MinYear = 2012
VAR MaxYear = 2031
RETURN
ADDCOLUMNS (
    FILTER (
        CALENDARAUTO( ),
        AND ( YEAR ( [Date] ) >= MinYear, YEAR ( [Date] ) <= MaxYear )
    ),
    "Year", YEAR ( [Date] ),
    "Month Name", FORMAT ( [Date], "mmmm" ),
    "Month Number", MONTH ( [Date] )
)

What I find especially confusing is the fact that this command worked in an earlier dashboard but would not work now. Here is the screenshot of my older dashboard where it worked as intended:

and here is a screenshot of how it fails to work:

Does anyone know why this is the case and what the remedy to this might be?

Thanks in advance!

[amitchandak · Accepted solution]

@ThomasSan , better you do like that

Date =
VAR MinYear = 2012
VAR MaxYear = 2031
RETURN
ADDCOLUMNS (
calendar( date(MinYear,1,1) ,Date(MaxYear,12,31)
),
"Year", YEAR ( [Date] ),
"Month Name", FORMAT ( [Date], "mmmm" ),
"Month Number", MONTH ( [Date] )
)

calendar auto will be limited by dates present in other tables

[ThomasSan]

Hi @amitchandak ,

your solution works perfectly. Thanks a lot!