Reply
avatar user
Anonymous
Not applicable

Group rows then pull back row data

Ok someone once helped me with this but i've clean forgotten how to do it because it's quite technical.

 

I need to group data based on Member ID, by the latest date. This creates a list of Unique Member IDs. But in order to do this, I need to remove the Index else it won't focus just on grouping Member ID. But then once I've done this, I want the Index associated with the saved rows, to come back. 

 

How do I do this? 

2 REPLIES 2
TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

Could you please share some sample data and expected result to us for analysis? 

Best Regards,

Teige

avatar user
Anonymous
Not applicable

Hi @TeigeGao 

 

Sure thing, I can't upload data - this forum doesn't let me - so i've drawn a pretty picture instead I hope it makes sense!

 

Grouping example.png

avatar user

Helpful resources

Announcements
March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)