Remove duplicate rows based on column value

[Fox5]

Hi everyone

Once again, your help to solve my current problem is much appreciated 😊

My table looks somwhat like this:

Column A	Column B
P100	5
P100	20
P101	25
P102	1
P103	8
P104	9
P104	37
P104	8

I need to remove the rows that contain multiple values in column A based on values in column B. More specifically, of all the rows containing the same value in column A I need to keep the row that contains the highest value in column B. The result must be like this:

Column A	Column B
P100	20
P101	25
P102	1
P103	8
P104	37

[v-shex-msft · Accepted solution]

HI @Fox5,

I'd like to suggest you create a new calculated table with following formulas:

newTable =
SUMMARIZE ( Table1, [Column A], "MaxB", MAX ( Table1[Column B] ) )

Regards,

Xiaoxin Sheng

[Fox5]

Perfect. Thank you very much 😊