title: Power BI remove duplicates based on max value
body: <p>I have 2 column; ID CODE, value</p>
  
  <p><a href="https://i.stack.imgur.com/EC75m.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EC75m.png" alt="(this is my column)"></a></p>
  
  <p>Remove duplicates function will remove the examples with the higher value and leave the lower one. Is there any way to remove the lower ones? The result I expected was like this.</p>
  
  <p><a href="https://i.stack.imgur.com/REni0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/REni0.png" alt="result I expected"></a></p>
  
  <p>I've tried Buffer Table function before but it doesn't work. Seems like Buffer Table just works with date-related data (newest-latest).</p>