Forum Discussion
Solved
Remove Duplicate values without deleting a row
Hi All, I need to remove the duplicate values in a row without deleting the row. For example, in third row output should be "A" only instead of "A,A". I am trying with this expression Measur...
Does it have to be in DAX or would Power Query work too?
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WctRxUorVAdIQUgdGB+gEwFluSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Industry = _t]), #"Replaced Value" = Table.ReplaceValue(Source,each [Industry],each Text.Combine(List.Distinct(Text.Split([Industry],",")),","),Replacer.ReplaceValue,{"Industry"}) in #"Replaced Value"How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
Does it have to be in DAX or would Power Query work too?
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WctRxUorVAdIQUgdGB+gEwFluSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Industry = _t]),
#"Replaced Value" = Table.ReplaceValue(Source,each [Industry],each Text.Combine(List.Distinct(Text.Split([Industry],",")),","),Replacer.ReplaceValue,{"Industry"})
in
#"Replaced Value"How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".