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.
Hello,
Can someone tell me how to quickly duplicate duplicates which at the end of the respective name is only ever there.
Thanks and Greetings
Solved! Go to Solution.
My interpretation of your question in this video resulting in the following code (the first line was created when I entered the data before I started the recording):
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8k0sSk7NcUotTVfILFbIz8upVEgtSy1SKMlILUpVitUhRoVbak5mRbyBpYEpSEUeBbIYpscCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t]), #"Filtered Rows" = Table.SelectRows(Source, each Text.EndsWith([Name], "only ever there")), #"Kept Duplicates" = let columnNames = {"Name"}, addCount = Table.Group(#"Filtered Rows", columnNames, {{"Count", Table.RowCount, type number}}), selectDuplicates = Table.SelectRows(addCount, each [Count] > 1), removeCount = Table.RemoveColumns(selectDuplicates, "Count") in Table.Join(#"Filtered Rows", columnNames, removeCount, columnNames, JoinKind.Inner), #"Added Custom" = Table.AddColumn(#"Kept Duplicates", "Custom", each {1..2}), #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"), #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Custom"}) in #"Removed Columns"
My interpretation of your question in this video resulting in the following code (the first line was created when I entered the data before I started the recording):
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8k0sSk7NcUotTVfILFbIz8upVEgtSy1SKMlILUpVitUhRoVbak5mRbyBpYEpSEUeBbIYpscCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t]), #"Filtered Rows" = Table.SelectRows(Source, each Text.EndsWith([Name], "only ever there")), #"Kept Duplicates" = let columnNames = {"Name"}, addCount = Table.Group(#"Filtered Rows", columnNames, {{"Count", Table.RowCount, type number}}), selectDuplicates = Table.SelectRows(addCount, each [Count] > 1), removeCount = Table.RemoveColumns(selectDuplicates, "Count") in Table.Join(#"Filtered Rows", columnNames, removeCount, columnNames, JoinKind.Inner), #"Added Custom" = Table.AddColumn(#"Kept Duplicates", "Custom", each {1..2}), #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"), #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Custom"}) in #"Removed Columns"
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |