title: Remove Rows With Similar Values in Power BI / Power Query
body: <p>I am working with a data set that has some duplicate rows.  The rows are not straight duplicates, but have a time stamp less than a second apart.  I'd like to remove these duplicates, but the question is how.</p>
  
  <p>My current plan is to add two new columns, which are copies of the time stamp column but one has a second added to it and the other has a second removed from it.  I can then add steps to remove rows which have all other values the same, but have the same time stamp as time stamp plus one or minus one.  Doing one after the other should eliminate duplicates but not remove truly unique rows.</p>
  
  <p>How can I accomplish this in Power Query?</p>