Need calculating column like If the duplicates records in the column first record is new

[Venkateswara_ra]

In a column we have duplicate records the first record will be "New" remaining all records will be "Old"

ID	type	OutPut column
2	average	New
2	average	Old
4	average	new
5	average	new
6	average	new
6	but	OLD
6	but	OLD
7	but	New
7	average	OLD
7	average	old
7	but	Old

[amitchandak]

@Venkateswara_ra ,

Add an index column: https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Create a new column
new column =
var _min = minx(filter(Table, [ID] =earlier([ID])),[index])
return
if([index] =_min , "New", "Old")