Create a calculated column last 12 months

[renatopnovaes]

 I have a dCalendar table with a single column dCalendar[date] with dates in the format "dd/mm/yy". I need to create a calculated column that will say if the column date is greater or less than 12 months in relation to MAX(dCalendar[date]. Can I do that?

[renatopnovaes]

Thank You!  Jesus loves you

[Greg_Deckler · Accepted solution]

@renatopnovaes Perhaps something like:

Column =
  VAR __Max = MAX('dCalendar'[Date])
  VAR __12MonthsPrior = EDATE(__Max,-12)
RETURN
  IF([Date]<=__12MonthsPrior,"Prior","Current")