Delate duplicate rows

[Fidzi8]

Hi,
I need advice.

I have in PowerQuery duplicate rows by ID. I sort table by Name.1 and then dalete duplicate rows by ID.


Then I see just sixth row but I need to see just first row. 

Thank you
Ondřej

[mahoneypat · Accepted solution]

In the Formula Bar, try wrapping your Table.Sort step with Table.Buffer(     ).

Bug warning for Table.Sort and removing duplicates... - Microsoft Power BI Community

Pat

[Greg_Deckler · Accepted solution]

@Fidzi8 You need a Table.Buffer like this:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTI0UIrVgTCNEExjCNMIocAIocAIqiAWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}, {"Column2", Int64.Type}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Column2", Order.Descending}}),
    Buffer = Table.Buffer(#"Sorted Rows"),
    #"Removed Duplicates" = Table.Distinct(Buffer, {"Column1"})
in
    #"Removed Duplicates"

[mahoneypat · Accepted solution]

In the Formula Bar, try wrapping your Table.Sort step with Table.Buffer(     ).

Bug warning for Table.Sort and removing duplicates... - Microsoft Power BI Community

Pat