Deduplicate with condition in power query power bi

[Anja1]

I have a table and i want deduplicate.

Example:

member	number
A	5
A	4
A	3
A	2
A	1
B	3
B	2
B	1
C	4
C	3
C	2
C	1
D	2
D	1

I want to keep de highest number per member and the others delete.

How can I do this in power query in power bi?

I hope someone has the solution for me 🤔

Anja

[Anja1]

This is great, this is the solution where I am looking for.

I need some other colums of the data and when I use Advanced I can take the other colums with this condition.

Your explanation is very goed.

[dufoq3]

You're welcome.

[dufoq3 · Accepted solution]

Hi @Anja1, group by member.

Result