https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-new-added-item-to-the-database/m-p/2523789#M70488 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="173707" data-lia-user-login="akito" class="lia-mention lia-mention-user">akito</a> , Create a measure</P> <P>&nbsp;</P> <P>cnt = countrows(Table)</P> <P>&nbsp;</P> <P>This measure will give new</P> <P>countx(Values(Table[Initative ID]), If([cnt]=1, [Initative ID], blank()))</P> <P>&nbsp;</P> <P>old</P> <P>&nbsp;</P> <P>countx(Values(Table[Initative ID]), If([cnt]&gt;1, [Initative ID], blank()))</P> <P>&nbsp;</P> Wed, 18 May 2022 15:28:20 GMT amitchandak 2022-05-18T15:28:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-new-added-item-to-the-database/m-p/2523603#M70478 <P>Hi All,</P><P>Trying to tag those new ones as "New" in new column, is there any easy way&nbsp; - please let me know.</P><P><img /></P><P>Regards,</P><P>Akito</P> Wed, 18 May 2022 14:18:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-new-added-item-to-the-database/m-p/2523603#M70478 akito 2022-05-18T14:18:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-new-added-item-to-the-database/m-p/2523789#M70488 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="173707" data-lia-user-login="akito" class="lia-mention lia-mention-user">akito</a> , Create a measure</P> <P>&nbsp;</P> <P>cnt = countrows(Table)</P> <P>&nbsp;</P> <P>This measure will give new</P> <P>countx(Values(Table[Initative ID]), If([cnt]=1, [Initative ID], blank()))</P> <P>&nbsp;</P> <P>old</P> <P>&nbsp;</P> <P>countx(Values(Table[Initative ID]), If([cnt]&gt;1, [Initative ID], blank()))</P> <P>&nbsp;</P> Wed, 18 May 2022 15:28:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-new-added-item-to-the-database/m-p/2523789#M70488 amitchandak 2022-05-18T15:28:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-new-added-item-to-the-database/m-p/2532724#M71083 <P>Cool, Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a>&nbsp; - This works</P> Mon, 23 May 2022 09:20:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-new-added-item-to-the-database/m-p/2532724#M71083 akito 2022-05-23T09:20:41Z