Max Value from the all column

hyugo_v 

I'm not sure how you've tried but it should work. See it all at play in the attached file, where the latest (max) date in the column is 31/12/2020

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

hyugo_v 

You're quite right. It doesn't work well. Try this improved version:

LTM status V2 = 
VAR max_ = MAX ( Table1[Date] )
VAR date1_ = EDATE(max_,-12)
VAR date2_ = EDATE(max_,-24)
RETURN
SWITCH ( TRUE(), Table1[Date] > date1_, "LTM", Table1[Date] > date2_, "LTM-1", "N/A" )

You might want to change the inequality depending on where you want to include the edge dates

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers