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
Icon for Super User rankSuper 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
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous add a measure using following expression:

 

Recent Date = 
CALCULATE ( MAX ( Table[Date] ), ALLEXCEPT ( Table, Table[Vehicle] ) )

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡