Delete row, keep latest date for duplicate id

[anDAXin]

Hi !

I would like that, Delete row, keep latest date for duplicate id. 

Example: 

Thanks in advance,

[talespin · Accepted solution]

hi @anDAXin ,

If you want to delete row permanently from your Data model, I would suggest doing it in Power Query. 

Min Date by Category =

CALCULATE( MIN( TestTbl5[Dt]), REMOVEFILTERS(TestTbl5), VALUES(TestTbl5[Category]) )