title: Remove Duplicates based on latest date in power query
body: <p>I got a dataset that I am loading into my sheet via power query and wish to transform the data a little bit according to my liking before loading it in.</p>
  <p><a href="https://i.stack.imgur.com/tElS5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tElS5.png" alt="enter image description here" /></a></p>
  <p>To give a little more context, I have some ID's and I would like the older rows to be removed and the rows which have the newer date to be loaded in.</p>