title: Power Query Remove latest row of data did not work
body: <p>I have the table from excel file which have the structure like below;</p>
  
  <pre><code>Key     Report_Month      Amount
  001     31/01/2017        0
  001     28/02/2017        1000
  002     31/05/2017        0
  002     30/06/2017        60000
  </code></pre>
  
  <p>I need the latest row of each ID. The final result should be like this;</p>
  
  <pre><code>Key     Report_Month       Amount
  001     28/02/2017        1000
  002     30/06/2017        60000
  </code></pre>
  
  <p>So I started by sorting data by ID and ordering them by ascending and descending respectively. Then I removed the duplicated row by using ID in removing. but It show the first record of each ID. </p>
  
  <p>Here is my code </p>
  
  <pre><code>#"Sorted Rows" = Table.Sort(#"Changed Type1",{{"Key", Order.Ascending}, {"Report_Month", Order.Descending}}),
  #"Removed Duplicates" = Table.Distinct(#"Sorted Rows", {"Key"})
  </code></pre>
  
  <p>I have tried Group by ,but it showed only related columns (ID, and Date). I lost other columns. I don't think we can use Group By for solving this case. Please suggest me.</p>