Forum Discussion
Solved
Unique or Duplicate
Hello All I have a data file where the ticket number sometimes appears more than once and I'd like to create a column that says single or duplicate, but that when there is a duplicate the first i...
Hi FelippeAzevedo7 ,
If you want the first item of a duplicate ticket to appear as a single one, you will also need a sort field to determine the order, such as date, etc.
You can refer to the column expression below.
Unique/Duplicate = VAR CurIndex = 'Table'[Index] VAR MinIndex = CALCULATE(MIN('Table'[Index]),ALLEXCEPT('Table','Table'[Ticket])) RETURN IF(CurIndex=MinIndex,"Single","Duplicate")Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Hi FelippeAzevedo7 ,
If you want the first item of a duplicate ticket to appear as a single one, you will also need a sort field to determine the order, such as date, etc.
You can refer to the column expression below.
Unique/Duplicate =
VAR CurIndex = 'Table'[Index]
VAR MinIndex = CALCULATE(MIN('Table'[Index]),ALLEXCEPT('Table','Table'[Ticket]))
RETURN
IF(CurIndex=MinIndex,"Single","Duplicate")
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Hello
Many tks for the support.