How do I remove the right duplicate rows?

[ThomasWeppler]

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.

[JP_Wisco · Accepted solution]

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]

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

[mussaenda]