https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Delete-row-keep-latest-date-for-duplicate-id/m-p/3688257#M143290 <P>Hi !</P><P>&nbsp;</P><P>I would like that,&nbsp;Delete row, keep latest date for duplicate id.&nbsp;</P><P>Example:&nbsp;</P><P><img /></P><P>Thanks in advance,</P> Thu, 08 Feb 2024 12:05:45 GMT anDAXin 2024-02-08T12:05:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Delete-row-keep-latest-date-for-duplicate-id/m-p/3688257#M143290 <P>Hi !</P><P>&nbsp;</P><P>I would like that,&nbsp;Delete row, keep latest date for duplicate id.&nbsp;</P><P>Example:&nbsp;</P><P><img /></P><P>Thanks in advance,</P> Thu, 08 Feb 2024 12:05:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Delete-row-keep-latest-date-for-duplicate-id/m-p/3688257#M143290 anDAXin 2024-02-08T12:05:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Delete-row-keep-latest-date-for-duplicate-id/m-p/3688273#M143292 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="687403" data-lia-user-login="anDAXin" class="lia-mention lia-mention-user">anDAXin</a>&nbsp;,</P><P>&nbsp;</P><P>If you want to delete row permanently from your Data model, I would suggest doing it in Power Query.&nbsp;</P><P>&nbsp;</P><P><SPAN>Min Date </SPAN><SPAN>by</SPAN><SPAN> Category =</SPAN></P><DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>( </SPAN><SPAN>MIN</SPAN><SPAN>( </SPAN><SPAN>TestTbl5</SPAN><SPAN>[Dt]</SPAN><SPAN>), </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>(</SPAN><SPAN>TestTbl5</SPAN><SPAN>), </SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>TestTbl5</SPAN><SPAN>[Category]</SPAN><SPAN>) )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><img /><P>&nbsp;</P><P>&nbsp;</P></DIV></DIV> Thu, 08 Feb 2024 12:13:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Delete-row-keep-latest-date-for-duplicate-id/m-p/3688273#M143292 talespin 2024-02-08T12:13:14Z