title: Finding duplicate records in Power Query
body: <p>I am trying to find duplicate records in Power Query. I do not need to remove them, I would just need to identify them. I am putting up a sample here. </p>
  
  <p><a href="https://i.stack.imgur.com/htb7l.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/htb7l.png" alt="enter image description here"></a></p>
  
  <p>As you can see in the image below, the first record is actually not a duplicate unlike the row below. 
  I am pretty new to using power query and all I did here was what I would generally do in EXCEL: 
  <a href="https://i.stack.imgur.com/QVBGl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QVBGl.png" alt="enter image description here"></a></p>
  
  <p>I was wondering if somebody could tell me what could I be doing wrong here. Thank you</p>