Student Retention Term by Term and Year by Year

[Anonymous]

Hello - I am a beginner with Power BI and I am looking for a good way to display student retention term by term and year by year broken out by the Program and then drilling down by Student Program. I linked the data I was given to work with but Im not sure where to even start. Would anyone be willing to help me get started and then I can take it from there?   Student Retention 

[Anonymous]

Hi @Anonymous ,

You can refer the following links to create the retention report:

Higher Education Student Retention Report

Higher Education Analytics using Power BI #1: Retention

Customer Retention in Power BI: DAX Measures

Or you can explain your expected result with the logic and special examples, later we can provide the suitable solution. Thank you.

Best Regards

[Anonymous]

Thank you for your reply. I am very interested in this example - Higher Education Analytics using Power BI #1: Retention but the link to download and play with the data no longer exists.

[amitchandak]

@Anonymous , You need a separate Year/Date table, Joined to your table. And then need this year vs last year formula

//Only year vs Year, not a level below

This Year = CALCULATE(Count('Table'[Student Id]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(Count('Table'[Student ID]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

retain

Countx(filter( values(Table[Student ID]) , not(isblank([This Year])) && not(isblank([Last Year])) ) , [Student ID])

refer

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count:
Learn Power BI Advance - Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY