topic Re: Sort to Most Recent Result per Item in DAX Commands and Tips

Sort to Most Recent Result per Item

ladams — Wed, 19 Oct 2022 05:08:42 GMT

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.

Re: Sort to Most Recent Result per Item

amitchandak — Wed, 19 Oct 2022 05:21:47 GMT

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-f1c839ee884e

if you want new table then create it using

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

Re: Sort to Most Recent Result per Item

ladams — Wed, 19 Oct 2022 23:31:52 GMT

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