Rolling 12 months Retention

Question

Hi Users,&nbsp;I have a measure which gives me the retention&nbsp; as below. I looking for calculating the rolling retention for 12 months from a date. My question can i use the below retention measure to calculate Rolling retention for a date ? If yes then how do i start with thedax for it?&nbsp;Retention&nbsp; = DIVIDE([Staff Retained],[SOP Active staff],0) *100&nbsp;Staff Retained = [SOP Active staff] - [Terminations]&nbsp;SOP Active staff = VAR _FirstDayCurrentMonth =MIN( CalFiscal[Date] )RETURNCALCULATE (COUNT ('Hires term 2 4'[EMPLID]),FILTER ('Hires term 2 4','Hires term 2 4'[LAST_HIRE_DT]&lt;= _FirstDayCurrentMonth&amp;&amp; ('Hires term 2 4'[TERMINATION_DT] &gt;= _FirstDayCurrentMonth|| ISBLANK ( 'Hires term 2 4'[TERMINATION_DT]))))&nbsp;&nbsp;Terminations = CALCULATE(COUNT(Turnover[TERMINATION_DT]),USERELATIONSHIP(Turnover[TERMINATION_DT],CalFiscal[Date]))

farhanahmed · Accepted Answer

you can give this a try and see the results.
You just need to make sure that you have a date table that is marked as Date Table in your model. In the below example, the "DimDate" is the Date/Calendar table.
Rolling 12 Month Retention = CALCULATE(Retention,DATESINPERIOD(DimDate[DateSecAlternateKey],MAX(DimDate[DateSecAlternateKey]),-12,MONTH))
&nbsp;

Forum Discussion

Rolling 12 months Retention

2 Replies

Related content

Retention analysis

12-month rolling cumulative

Rolling accumulation

Rolling accumulation

Dax Time Intelligence Functions Weird behavior - 13 Month Rolling Calc