Date table via Dax till end of last month

[RK_JOB]

Hello,

Can someone please help me to modify this date table? I am looking for this date table to end dynamically at the end of last month rather than full year.

DATE = 
VAR MINYEAR = (YEAR(TODAY())) - 4
VAR MAXYEAR = YEAR(TODAY())
--VAR MAXMONTH = if (YEAR(TODAY() = 2022 MONTH(TODAY())-1
return
ADDCOLUMNS(
    FILTER(
CALENDARAUTO(),
    YEAR ( [DATE]) >= MINYEAR &&  YEAR ( [DATE]) <= MAXYEAR
 
  
    ),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"YearMonth", FORMAT([Date],"yyyymm"),
"Month Label", FORMAT([Date],"mmm"),
"QKey", QUARTER([Date])
)

Thanks,

RK

[johnt75]

Instead of CALENDARAUTO and filtering on years you could try CALENDAR( DATE( YEAR(TODAY()-4),1,1), EOMONTH(TODAY(), -1))

[RK_JOB · Accepted solution]

  Thanks. I had to just modify your formula a little bit to make it work. Thanks for your help.

CALENDAR( DATE( YEAR(TODAY())-4,1,1), EOMONTH(TODAY(), -1)), 

@johnt75