Which row will keep Table.Distinct(Table, {"Column"})

I just found out the hard way.

the algorithm goies top to bottom, so I having a set like this

number updated_on

inc0001 01/01/22

inc0001 02/01/22

would remove the second occurrence from the top.

I wanted to keep the most updated record, so i sorted the data first, but still the algorithm remove the same  record, ignoring any sorting

At the end I'm 99% positive that eliminate from top to bottom every reoccurrence...hoping that is not using a something faster and more difficult to predict and control.

In the past the same function in excel worked this way, so I hope is still the same

Cheers