Create a new table with only most recent entry for each element

[kbiscuit123]

Hi -

I have a table called Status and want to create a new table that only has the latest entry for each activity. See tables below. 

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:

filter(Latest,Latest[Date]=CALCULATE(max(Latest[Date]),ALLEXCEPT(Latest,Latest[Class])))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/