How to make my master calendar dynamic on year field ?

[Paulyeo11]

Hi All

i like to make make the min and max date value dynamic  , so that easy for maintenance.

Date = CALENDAR(Date(2017,01,01),date(2020,12,31))

Paul

[jdbuchanan71 · Accepted solution]

Date = CALENDAR(DATE(YEAR(TODAY())-3,01,01),DATE(YEAR(TODAY()),12,31))

[Paulyeo11]

Hi Sir

Thank you it work. Why your script does not consider the min date ?

Paul

[mahoneypat]

You can use MIN and MAX of one or more of your date columns in the model to be dynamic.  For example,

Date = CALENDAR(Date(YEAR(MIN(Table[DateColumn])),01,01),date(YEAR(MAX(Table[DateColumn])),12,31))