Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table and I want to remove duplicate values from old table to New Table
How do I do it?
Thank You!
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |