Calculated column - Max value based on two columns

Hi Experts   I am trying to work out the max value based on the Task ID and End Date as shown in the sample data below, need a calculated column and where we have the max value (new column) return ...