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.
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)