Forum Discussion
Retention analysis
Hi,
PBI file attached.
Hope this helps.
Hello Ashish,
I apply the formula which you gave me for retention analysis , but my output is giving me the sum instead of year by year retention , this is how my output looks like [ also i am trying to use this formula for the multiple programs [ please let me know what i am doing wrong here]
I appreciate all your help
Thank u
Hi,
In my screenshot, you can clearly see %. In your screenshots, i see an absolute figure. So you are obviously missing the division operation.
The division operation in my case is working like this :
I used the exact formula that you used
Recheck the relationships.
This is great Ashish, it works but i am looking more of a semester wise retention for example : for this particular example : the retention should be calculated like 26 - 26 (100%), then 26- 24( 92%), then 24-23( 95%), is it possible to achieve that and update this following table with semester wise retention across the semester ( please provide your thoughts)