Forum Discussion
NewbieJono
Post Partisan
Post PartisanLabel max date minus one year
i have a text label that displays the max date minus a year. i currently use - 365 and it seems to return the wrong month, if I change it to 366 it works. i am guessing its because of leap year? ...
Label - Last Year = EDATE( MAX ( 'DIM - Date Table'[Date] ) , -12 )
lbendlin
Super User
Super UserLabel - Last Year =
EDATE( MAX ( 'DIM - Date Table'[Date] ) , -12 )