Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I am guessing you have VIN as your dimension, if you do, then try this as your measure
FirstSortedValue([Odometer Value], -[Transaction Date])
I am guessing you have VIN as your dimension, if you do, then try this as your measure
FirstSortedValue([Odometer Value], -[Transaction Date])