Own date table is not properly filling itself out
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!
