Duplicate Rows in a table

[kalikumar]

1. To find Duplicate rows in a table based on a condition.

2. In the above image, i need to get duplicate rows based on Periods, Student ID & Date columns(if same set (i.e.,) periods,student id & date repeated,need to find that).

[Mahesh0016]

@kalikumarPlease Shre your ENDOUTPUT in table for more understanding.THANK YOU!!

[kalikumar]

Hi Mahesh,

This is the output I need,

1M-E101-Feb 28,2023 - Duplicate Rows present for this set

Thanks.

[Mahesh0016]

@kalikumar 
Go to power query >> Duplicate Current Table >> Remove Unique Column >> Than Home >> Keep Row >> Keep Duplicates.

@kalikumar i hope this helps you!!THANK YOU!!