topic Re: Own date table is not properly filling itself out in DAX Commands and Tips

Own date table is not properly filling itself out

ThomasSan — Fri, 11 Mar 2022 11:20:55 GMT

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!

Re: Own date table is not properly filling itself out

amitchandak — Fri, 11 Mar 2022 11:48:04 GMT

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

Re: Own date table is not properly filling itself out

ThomasSan — Fri, 11 Mar 2022 12:09:38 GMT

Hi amitchandak ,

your solution works perfectly. Thanks a lot!