Forum Discussion
ThomasWeppler
Impactful Individual
Impactful IndividualHow do I remove the right duplicate rows?
Hi power Bi community
I want to remove the everything but the top row. I thought remove duplicate would help me with that, but it seems like it removes everything based on my idx instead of my id. See example
Can anyone help me in the right direction? I would appreciate it greatly.
I will frequently apply a
- Group By id field(s), aggregating max date and all rows
- Expand all rows
- Filter rows where date = max date
- select id column and remove duplicates (in case you somehow had a true duplicate)
4 Replies
- JP_Wisco
Helper I
I will frequently apply a
- Group By id field(s), aggregating max date and all rows
- Expand all rows
- Filter rows where date = max date
- select id column and remove duplicates (in case you somehow had a true duplicate)
- ThomasWeppler
Thansks a lot. I used Min instead of Max and it worked like a charm.
- mussaenda
Community Champion
- mussaenda
I actually didn't get how they are duplicated but if you want to get only the top row, you can use the above function
