Does anybody know how I only show the last/biggets value in a column, grouped by name. My table looks like this:
I only want to see the sonny de boer with the name p-5089 in this table. Now I see him 2 times.
Hi,
Difficult to work out exactly how to Group correctly as I dont know the full data set, but you could try the below (used the sample data you gave above)
From this...
To this...
= Table.Group(#"Changed Type", {"Name"}, {{"Name2", each List.Max([Name2]), type nullable text}, {"Last Placement", each List.Max([Last Placement]), type nullable text}})
Hope that helps.
Hi,
Difficult to work out exactly how to Group correctly as I dont know the full data set, but you could try the below (used the sample data you gave above)
From this...
To this...
= Table.Group(#"Changed Type", {"Name"}, {{"Name2", each List.Max([Name2]), type nullable text}, {"Last Placement", each List.Max([Last Placement]), type nullable text}})
Hope that helps.
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
