Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Duplicate Rows in a table

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).

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Mahesh,

       

      This is the output I need,

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

       

      Thanks.

      • Mahesh0016's avatar
        Mahesh0016
        Super User
        3 years ago

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

        Anonymous i hope this helps you!!THANK YOU!!