Forum Discussion
Identify the most recent data
Hi, I have a data dump from a vehicle tracking system, that records the time, location etc each time a vehicle's ignition is switched on or off. A simplified view is as below: Vehicle Sta...
Anonymous
Add this in your vehicles table:
Sorry, thought that was all I needed - how can I edit that to pull through the other columns (status, location etc)?
Anonymous
If you need a new table that brings only the records for each vehicle with its latest date, add this code by clicking on the New Table under Home tab:
Latest Dates Table=
FILTER(
'Table',
VAR _MAX =
CALCULATE(
MAX('Table'[Time]),
ALLEXCEPT('Table',VEHICLES[Vehicle])
)
RETURN
'Table'[Time] = _MAX
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Thank you! I think this is exactly what we need 👍