Forum Discussion
Which row will keep Table.Distinct(Table, {"Column"})
Hi colleagues, Which row will keep Table.Distinct(Table, {"Column"}) for the rows with the same values in the "Column": First row? Last row? Random row? MS documentation has no explanation abo...
[SOLUTION]
After googling a lot, I fount this site explaining exactly what happened, and how to solve.
It’s simple, you just need add the buffer of the column you want to sort.
just add this step:
= Table.Buffer(Table.Sort( #"Linhas Classificadas",{{"data_lancamento", Order.Descending}}))
Source: https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/