Forum Discussion
Solved
Retention analysis
Dear team, I am working on calculting the retention between semesters per program, the data is organized in the different format so I am finding it difficult to caluclate the retention. Here is the ...
Hi,
PBI file attached.
Hope this helps.
Yes, you can. Please study my solution and adapt it to your needs.
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.