Looking for repeated lines or not with an unique ID

[Chema_Ortega_Ga]

Good morning to everyone. I hope you are all good!

I need to know if a line is repeated in a table looking for a unique ID (column "ID único"), since we know there are some repeated files. But I need to know which lines are repested.  the Table is: 

If the line is repeated, I need in another column that say "YES", and no repeated "NO". Does anyone know how to do this? Thanks a lot, best regards,

Chema Ortega

[Chema_Ortega_Ga]

Hi Pedar,

Thanks soooo much!!! That made the solution!!!! GREAT!!!!

Best regards,

Chema ortega

[Kedar_Pande · Accepted solution]

Create a calculated column

Is Repeated = 
IF(
COUNTROWS(
FILTER(
YourTableName, 
YourTableName[ID único] = EARLIER(YourTableName[ID único])
)
) > 1, 
"YES", 
"NO"
)

If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande