Max Value

[FrankC]

I would like to take a column based on the max transaction date.  I have a series of transaction dates and I want to know the odometer value per vin by the max transaction date for each vin.

[sunny_talwar · Accepted solution]

I am guessing you have VIN as your dimension, if you do, then try this as your measure

FirstSortedValue([Odometer Value], -[Transaction Date])