Remove duplicate rows?

[nmhung49]

I have a table and I want to remove duplicate values from old table to New Table

How do I do it?

Thank You!

[Zubair_Muhammad · Accepted solution]

HI @nmhung49

You can use this
File attached as well

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("ZdBLCsAgDIThu2RtwVifZ5He/xotUSIzXQkfLjL/nKISJEXt+7lUnjAlkSbTm/Q2zaTZtJAW00paTRtpM+2k3XSQDlONPCMu/81b+5QH6lq4v++DGtZwhRquUMMVarhCDVeo4Qo1XKGGK9Y4M7DGcaxx/Fv4vA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Month = _t, Year = _t, YearMonth = _t]),
    ChangedType = Table.TransformColumnTypes(Source,{{"Month", Int64.Type}, {"Year", Int64.Type}, {"YearMonth", type date}}),
FinalTable=Table.FromColumns({List.Distinct(ChangedType[Month]),List.Distinct(ChangedType[Year]),List.Distinct(ChangedType[YearMonth])})
    
in
    FinalTable