Calculated column - Max value based on two columns

[BlueWhite111]

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 expected result

Task ID	End Date	Value (£)	Expected Result
1	02/03/2023	10	10
1	03/03/2023	20
2	03/03/2023	30	30
2	13/03/2023	35	35
3	04/04/2023	8
3	11/04/2023	11
3	25/04/2023	55	55

[Ahmedx · Accepted solution]

pls try this