rolling 12 months
1 Topic
Rolling 12 months Retention
Hi Users, I have a measure which gives me the retention 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? Retention = DIVIDE([Staff Retained],[SOP Active staff],0) *100 Staff Retained = [SOP Active staff] - [Terminations] SOP Active staff = VAR _FirstDayCurrentMonth = MIN( CalFiscal[Date] ) RETURN CALCULATE ( COUNT ('Hires term 2 4'[EMPLID]), FILTER ( 'Hires term 2 4', 'Hires term 2 4'[LAST_HIRE_DT]<= _FirstDayCurrentMonth && ( 'Hires term 2 4'[TERMINATION_DT] >= _FirstDayCurrentMonth || ISBLANK ( 'Hires term 2 4'[TERMINATION_DT])))) Terminations = CALCULATE(COUNT(Turnover[TERMINATION_DT]), USERELATIONSHIP(Turnover[TERMINATION_DT],CalFiscal[Date]))Solved1.8KViews0likes2Comments