Count by End of Month--Reposting

https://community.powerbi.com/t5/Desktop/Count-by-End-of-Month-Reposting/m-p/507546#M237114

Please go through the above link

For example for Student Number 30830 the Effective date for Status Change is on same day but there is other field i didn't mention in sample data is UpdatedDate.

If the status is changed in same month it should show the updated Status in that month.

 For Pending below is the code, but we are getting above result in Pending and Approved.Please let me know if you have any questions and help me out on this.

 Pending2 = 
VAR __minDate =
 MIN ( 'Date'[Date] )
VAR __maxDate =
 MAX ( 'Date'[Date] )
VAR __tmpTable =
 SUMMARIZE (
 tblStudent,
 tblStudent[StudentGUID],
 tblStudent[StudentNumber],
 tblStudent[StudentStatusID],
 "__UpdatedDate", MAX ( [UpdatedDate] )
 )
VAR __tmpTable1 =
 ADDCOLUMNS (
 __tmpTable,
 "__Status", MAXX (
 FILTER (
 tblStudent,
 tblStudent[StudentGUID],
 = EARLIER ( [StudentGUID],)
 && [__UpdatedDate] = EARLIER ( [__UpdatedDate] )
 ),
 [StudentStatusID]
 )
 )
RETURN
 COUNTROWS (
 FILTER (
 __tmpTable,
 [__UpdatedDate] >= __minDate
 && [__UpdatedDate] <= __maxDate
 && tblStudent[StudentStatusID]=2 )
 )

Please help me out on this