Removing Duplicate Rows by Date Updated

[tktmastr]

Hi all,

I've read several posts on this but for some reason I can't get it right - I've tried grouping and a few different formulas.

Using the sample table below, I would like "Rating ID" 1 and 3 removed since they were replaced by newer ratings

Rating ID	Customer ID	Date Updated	Rating
1	1729	1/15/2021	3
2	1520	1/15/2021	1
3	1103	1/15/2021	3
4	1639	1/15/2021	5
5	1568	1/15/2021	2
6	1729	2/1/2021	2
7	1774	2/1/2021	3
8	1902	2/1/2021	4
9	1103	2/1/2021	4
10	1211	2/1/2021	3

Thanks in advance!

[tktmastr · Accepted solution]

I figured it out with this video: Power BI Remove Duplicate Records And Keep Most Recent - YouTube

If anyone else has the same issue, you need to add Table.Buffer to the query before you sort by date and remove dups

[vanessafvg]

are you wanting to filter your table or create a measure?    what is your expected results?  Do you want this filtered out the dataset or just not reported on?

[tktmastr]

Removed from the dataset. I don't want to see it in the data table at all