Calculated column for highest rank in each group

[Anonymous]

I have the following new table based upon another which has a ranking for each StudentID based on dates and other data within the original table.  As the Academic Year moves forward additional rows are brought into the new table, so the rows for each student and therefore the rank will increase:

StudentID	Rank
Student1	1
Student1	2
Student1	3
Student2	1
Student2	2
Student2	3
Student3	1
Student3	2
Student4	1
Student4	2
Student4	3
Student4	4

Within this new table I wish to add a column which identifies as TRUE or FALSE which row is the highest ranked for each studentID, as follows.  Again this will change as new rows are added through the year:

StudentID	Rank	HighestRank?
Student1	1	FALSE
Student1	2	FALSE
Student1	3	TRUE
Student2	1	FALSE
Student2	2	FALSE
Student2	3	TRUE
Student3	1	FALSE
Student3	2	TRUE
Student4	1	FALSE
Student4	2	FALSE
Student4	3	FALSE
Student4	4	TRUE

All help gratefully received, thank you.

[AlB]

Hi @Anonymous 

HighestRank? =
VAR max_ =
    CALCULATE ( MAX ( Table1[Rank] ), ALLEXCEPT ( Table1, Table1[StudentID] ) )
RETURN
    Table1[Rank] = max_

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak · Accepted solution]

@Anonymous , Create a new column like

new column =
if([Rank] =maxx(filter(Table, [StudentID] = earlier([StudentID])),[Rank]), True(), false())

[Anonymous]

That seems to work perfectly, thank you