Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    Add this in your vehicles table:

    Lastest Time = CALCULATE(MAX('Table'[Time]),'Table'[Vehicle]=EARLIER(VEHICLES[Vehicle]))

    ________________________

    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 🙂

    YouTube, LinkedIn
Fowmy's avatar
Fowmy
Super User
6 years ago

Anonymous 

Add this in your vehicles table:

Lastest Time = CALCULATE(MAX('Table'[Time]),'Table'[Vehicle]=EARLIER(VEHICLES[Vehicle]))

________________________

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 🙂

YouTube, LinkedIn
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you! Thought it was an easy thing, I was just missing EARLIER.