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
richbenmintz's avatar
richbenmintz
Resident Rockstar
6 years ago

Hi Anonymous,

 

Wow parry2k and Fowmy  are fast, 

 

Another approach would be to derive the rows you are looking for during data ingestion. see the linked .pbix.

essentially ranks the data in power query then creates a filtered table  where the rank = 1

 

sample.pbix 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I like the look of your solution, saves the need for the second table, but I'm not sure how you got to the stage in your screenshot? I have very limited knowledge of the query editor 😕