Power Query - remove select row duplicates based on a sequential row index?

[SOQLee]

In Power Query, I have a [RID] column set up that identifies the rows sequentially. I would like to remove the first UserID duplicate. Does anyone know how to write the formula in Power Query?

For example:

RID | UserID | Code
1 | 999999999 | Red
2 | 999999999 | Orange
3 | 888888888 | Red

 

[ImkeF]

Table.RemoveDuplicates will always keep the first row.
So if you sort your table on RID ascending, this should normally do.
But there is a kind of a bug in Power Query that won't keep the sort-order, unless you wrap your sorting-step with a Table.Buffer:

Table.Buffer(Table.Sort(Source,{{"RID", Order.Ascending}}))

 

[SOQLee]

Appreciate the quick reply! I wasn't aware of the bug. I sorted RID in descending order and wrapped the step with a Table.Buffer. Worked like a charm. Thank you

Table.RemoveDuplicates will always keep the first row.
So if you sort your table on RID ascending, this should normally do.
But there is a kind of a bug in Power Query that won't keep the sort-order, unless you wrap your sorting-step with a Table.Buffer:

Table.Buffer(Table.Sort(Source,{{"RID", Order.Ascending}}))