Forum Discussion
Retention analysis
Hi,
PBI file attached.
Hope this helps.
Hey Harpreet1405_12 ,
I have difficulties understanding what data looks like and what you want to achieve. For this reason, I recommend that you prepare a pbix file that contains sample data but reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or Dropbox and share the link. If you do not use the manual input method for the sample data, make sure that the sample data is available in a spreadsheet and share this spreadsheet as well.
Do not forget to explain the expected result based on the sample data.
Regards,
Tom
Here is the link of the spreadsheet which has a sample data set i am working on. The enrolment data grouped by Audit date make more sense and it will give you the output which is listed in above screenshot ( In this screenshot i transpose the semester data into column and then count the distinct unique id grouped together by audit date). I want to achieve something like this:
Hi,
PBI file attached.
Hope this helps.
Hello Ashish,
Can we track by semester ( i mean semester 1 , semester 2, semester 3, and so on)? and also listed by Year. something like this :
Instead of months
The retention of unique id from one semetesr to 2 and 2nd to 3rd an dthen 3rd to 4th etc. how many people we loose from start to completion of the module. Does it make sense?
This is great, thank you so much for your response
