Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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..
Thanks so much in advance.
Simone
Solved! Go to 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'))
)
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'))
)
thanks @tamerj1 this definitely works in DAX. but I am looking to solve in power editor.. because this is the first of multiple steps.
@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