Sort to Most Recent Result per Item

[ladams]

Hi Guys, 

*Dummy data here*

I want to sort out various rows, with multiple rows of each phone number to end up with a table showing a unique list of phone numbers, and showing the ‘Stage’ given the most recent record creation.

Below, 2nd image, is nearly there, but frustratingly only shows the highest number, instead of most recent. E.g. 4) added on 1st of Jan is shown instead of 5) added on 10th of Jan.

Nearly there results table.

[amitchandak · Accepted solution]

@ladams , You can solve it by using measures too, Not need to create additional tbale. see if this can help

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

if you want new table then create it using

lasnonblankvalue(Table[Date], Max(Table[Phone])

[ladams]

Thank you very much, your video was siper helpful for this. Im going through all your other helpful videos on your channel now.