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 i...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
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!!