Forum Discussion
Identify the most recent data
Anonymous
Add this in your vehicles table:
Anonymous
Add this in your vehicles table:
Thank you! Thought it was an easy thing, I was just missing EARLIER.
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.⚡
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 👍
