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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
TFernandes_2022
Frequent Visitor

Highest score by person and category

 I have a database with several rankings by category,

This example table is a sample of the data, I need to remove the red lines from this table.

TFernandes_2022_0-1673303824261.png

In this table, only the highest score (Column E) of each Rider (Column B) in each category (Column C) will remain, no column can be removed

Is it possible to do this in Power Query?

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

=Table.FromRecords(Table.Group(PreviousStepName,{"Cavaleiro","Categoria"},{"n",each Table.Max(_,"Pts Dia1")})[n])

View solution in original post

1 REPLY 1
wdx223_Daniel
Super User
Super User

=Table.FromRecords(Table.Group(PreviousStepName,{"Cavaleiro","Categoria"},{"n",each Table.Max(_,"Pts Dia1")})[n])

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Users online (2,991)