Forum Discussion
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 months in relation to MAX(dCalendar[date]. Can I do that?
renatopnovaes Perhaps something like:
Column = VAR __Max = MAX('dCalendar'[Date]) VAR __12MonthsPrior = EDATE(__Max,-12) RETURN IF([Date]<=__12MonthsPrior,"Prior","Current")
2 Replies
Thank You! Jesus loves you
renatopnovaes Perhaps something like:
Column = VAR __Max = MAX('dCalendar'[Date]) VAR __12MonthsPrior = EDATE(__Max,-12) RETURN IF([Date]<=__12MonthsPrior,"Prior","Current")
