Cohort Tracking in Power BI

Question

I need to build a student cohort tracking pbix so as to show students who have progressed onto the next consecutive year, students who have continued their studies and other similar metrics. Currently, I have a standard star schema as follows:

Fact Enrolment – Logs all enrolment activity for each student (multiple records can exist in the fact for each student based on different years, statuses, courses etc)

Student – Shows all students and their personal details such as email addresses, phone numbers etc. I’d rather not build upon this table as it is quite large as it currently stands.

Year of Study - This table helps to identify which year a student is studying in (e.g second year)

University Academic Year – This lists all academic years (e.g. 2017/18)

Student Status Per Year - This table lists all the possible statuses a student can have for a particular year of their degree such as ‘Current Student’, ‘withdrawn’, ‘transferred’

I was thinking of building a dimension in Power Query which shows cohort tracking for each student and links back to the fact in the standard one-to-many relationship. This will enable end-users to slice the data further by faculty etc. However, I’m not entirely sure how to do this. I was thinking of using Cohort Analysis but this does not appear to do what I need it to.

Any advice would be much appreciated.