Forum Discussion

renatopnovaes's avatar
renatopnovaes
Helper I
4 years ago
Solved

Create a calculated column last 12 months

 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 mo...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    renatopnovaes Perhaps something like:

    Column =
  VAR __Max = MAX('dCalendar'[Date])
  VAR __12MonthsPrior = EDATE(__Max,-12)
RETURN
  IF([Date]<=__12MonthsPrior,"Prior","Current")
renatopnovaes's avatar
renatopnovaes
Helper I
4 years ago

Thank You!  Jesus loves you