Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ladams
New Member

Sort to Most Recent Result per Item

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.

 

ladams_2-1666156077018.png

 

 

Nearly there results table.

ladams_1-1666156045626.png

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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])

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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])

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors