Calculate Graduations of a students

[Anonymous]

Hi All, 

I have this issue and I will appreciate your help..

I have this data set .of students (5 in this example) and I would like to know when they graduate

in this example the yellow.. i.e. the first student is graduating in Jan 23.. 

I have already created the model... but with my list expand ... I only know until they appear as 1.. not when they became 0. (yellow)

Any idea?

I have added the excel with my query..

https://docs.google.com/spreadsheets/d/1QRfYxJoHUWaSwJ9H6o6QN3gzNBzxdgK-/edit?usp=sharing&ouid=10001... 

Thanks so much in advance.

Simone

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please refer to attched sample file with the solution

Rolling Enollment:=
VAR CurrentDate= MAX('Calendar'[Date])
RETURN
    SUMX(
        CALCULATETABLE(VALUES(Table1[Matricula]),'Calendar'[Date]<=CurrentDate,ALL('Calendar')),
	CALCULATE(MAX(Table1[Enrollment]), ALL('Calendar'))
    )

[Anonymous]

thanks @tamerj1  this definitely works in DAX. but I am looking to solve in power editor.. because this is the first of multiple steps.

[Anonymous]

@tamerj1 it looks similar to something you have created here..  https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-Student-Journey/m-p/2684876#M80554 but I am not sure how to apply in Power Editor. Thank