Forum Discussion
Solved
Deduplicate with condition in power query power bi
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
3 Replies
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
Community Champion
You're welcome.
