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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anja1
New Member

Deduplicate with condition in power query power bi

I have a table and i want deduplicate.

 

Example:

membernumber
A5
A4
A3
A2
A1
B3
B2
B1
C4
C3
C2
C1
D2
D1

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

1 ACCEPTED SOLUTION
dufoq3
Super User
Super User

Hi @Anja1, group by member.

 

dufoq3_2-1713620603463.png

 

Result

dufoq3_1-1713620541017.png


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

View solution in original post

3 REPLIES 3
Anja1
New Member

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.

 

 

You're welcome.


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

dufoq3
Super User
Super User

Hi @Anja1, group by member.

 

dufoq3_2-1713620603463.png

 

Result

dufoq3_1-1713620541017.png


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors