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.
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
Industry
A,B
A
A,A
A,P,P
A,P,F
OutPut
A,B
A
A
A,P
A,P,F
Thanks in advance
Solved! Go to Solution.
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".
Thank you. It worked
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".
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 |
---|---|
16 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |