topic Re: Student Retention Term by Term and Year by Year in DAX Commands and Tips

Student Retention Term by Term and Year by Year

Anonymous — Thu, 03 Nov 2022 19:26:16 GMT

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

Re: Student Retention Term by Term and Year by Year

amitchandak — Fri, 04 Nov 2022 02:15:19 GMT

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

Re: Student Retention Term by Term and Year by Year

Anonymous — Fri, 04 Nov 2022 06:17:21 GMT

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

Re: Student Retention Term by Term and Year by Year

Anonymous — Fri, 04 Nov 2022 16:01:09 GMT

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.