Forum Discussion
Solved
How 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. S...
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)
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)
Thansks a lot. I used Min instead of Max and it worked like a charm.
