Mileage at max datetime

[johngouws]

Hi. I need to calculate when vehicles are nearing their service mileage. I am getting the latest mileage of the vehicle from certain event logs. These events are timestamped. The data is as below: The highlighted line is the correct value I am looking for. I would prefer to have the result in a Dimension rather than a Measure. 

When I use "Num(AGGR(max({<[Departure DateTime]={'$(=max([Departure DateTime]))'} >}[End OdoMeter]),[Registration Number]),'# ##0')" it returns the max odometer for all the registration numbers. I need to show the latest odometer reading for each registration number. What am I doing wrong?    

Thank you very much for the assistance. 

[sunny_talwar]

Sounds good.