topic Need calculating column like If the duplicates records in the column first record is new in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-calculating-column-like-If-the-duplicates-records-in-the/m-p/1564938#M31112 <P>In a column we have duplicate records the first record will be "New" remaining all records will be "Old"</P><TABLE><TBODY><TR><TD>ID</TD><TD>type</TD><TD>OutPut column</TD></TR><TR><TD>2</TD><TD>average</TD><TD>New</TD></TR><TR><TD>2</TD><TD>average</TD><TD>Old</TD></TR><TR><TD>4</TD><TD>average</TD><TD>new</TD></TR><TR><TD>5</TD><TD>average</TD><TD>new</TD></TR><TR><TD>6</TD><TD>average</TD><TD>new</TD></TR><TR><TD>6</TD><TD>but</TD><TD>OLD</TD></TR><TR><TD>6</TD><TD>but</TD><TD>OLD</TD></TR><TR><TD>7</TD><TD>but</TD><TD>New</TD></TR><TR><TD>7</TD><TD>average</TD><TD>OLD</TD></TR><TR><TD>7</TD><TD>average</TD><TD>old</TD></TR><TR><TD>7</TD><TD>but</TD><TD>Old</TD></TR></TBODY></TABLE> Tue, 22 Dec 2020 10:42:29 GMT Venkateswara_ra 2020-12-22T10:42:29Z Need calculating column like If the duplicates records in the column first record is new https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-calculating-column-like-If-the-duplicates-records-in-the/m-p/1564938#M31112 <P>In a column we have duplicate records the first record will be "New" remaining all records will be "Old"</P><TABLE><TBODY><TR><TD>ID</TD><TD>type</TD><TD>OutPut column</TD></TR><TR><TD>2</TD><TD>average</TD><TD>New</TD></TR><TR><TD>2</TD><TD>average</TD><TD>Old</TD></TR><TR><TD>4</TD><TD>average</TD><TD>new</TD></TR><TR><TD>5</TD><TD>average</TD><TD>new</TD></TR><TR><TD>6</TD><TD>average</TD><TD>new</TD></TR><TR><TD>6</TD><TD>but</TD><TD>OLD</TD></TR><TR><TD>6</TD><TD>but</TD><TD>OLD</TD></TR><TR><TD>7</TD><TD>but</TD><TD>New</TD></TR><TR><TD>7</TD><TD>average</TD><TD>OLD</TD></TR><TR><TD>7</TD><TD>average</TD><TD>old</TD></TR><TR><TD>7</TD><TD>but</TD><TD>Old</TD></TR></TBODY></TABLE> Tue, 22 Dec 2020 10:42:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-calculating-column-like-If-the-duplicates-records-in-the/m-p/1564938#M31112 Venkateswara_ra 2020-12-22T10:42:29Z Re: Need calculating column like If the duplicates records in the column first record is new https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-calculating-column-like-If-the-duplicates-records-in-the/m-p/1564950#M31115 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="237066" data-lia-user-login="Venkateswara_ra" class="lia-mention lia-mention-user">Venkateswara_ra</a> ,</P> <P>Add an index column: <A href="https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi" target="_blank">https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi</A></P> <P>&nbsp;</P> <P>Create a new column <BR />new column = <BR />var _min = minx(filter(Table, [ID] =earlier([ID])),[index])<BR />return <BR />if([index] =_min , "New", "Old")</P> Tue, 22 Dec 2020 10:57:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-calculating-column-like-If-the-duplicates-records-in-the/m-p/1564950#M31115 amitchandak 2020-12-22T10:57:26Z