Forum Discussion
Powereports
Helper I
Helper IRolling 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 ca...
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))It worked Farhan.. Thanks for the solution.
FarhanAhmed
Community Champion
Community Championyou 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))
PowereportsIt worked Farhan.. Thanks for the solution.