Forum Discussion

Harpreet1405_12's avatar
Harpreet1405_12
Helper III
1 year ago
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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    PBI file attached.

    Hope this helps.

     

    retention.pbix108 KB
Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

PBI file attached.

Hope this helps.

 

retention.pbix108 KB
Harpreet1405_12's avatar
Harpreet1405_12
Helper III
1 year ago

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

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    Yes, you can.  Please study my solution and adapt it to your needs.

    • Harpreet1405_12's avatar
      Harpreet1405_12
      Helper III
      1 year ago

      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

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        1 year ago

        Hi,

        In my screenshot, you can clearly see %.  In your screenshots, i see an absolute figure.  So you are obviously missing the division operation.