Forum Discussion

anDAXin's avatar
anDAXin
New Member
2 years ago
Solved

Delete row, keep latest date for duplicate id

Hi !

 

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

Example: 

Thanks in advance,

Date
delete
ID
Row
  • talespin's avatar
    talespin
    2 years ago

    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]) )
     

     

     

1 Reply

  • talespin's avatar
    talespin
    Solution Sage
    2 years ago

    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]) )