topic Re: Remove Duplicate values without deleting a row in Developer

Remove Duplicate values without deleting a row

Kavya123 — Fri, 17 Feb 2023 05:52:30 GMT

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

Measure = CALCULATE(CONCATENATEX( VALUES('Organization Detail'[Industry]),'Organization Detail'[Industry],","))

Industry

A,B

A,A

A,P,P

A,P,F

OutPut

A,B

A,P

A,P,F

Thanks in advance

Re: Remove Duplicate values without deleting a row

lbendlin — Mon, 20 Feb 2023 00:00:07 GMT

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".

Re: Remove Duplicate values without deleting a row

Kavya123 — Mon, 20 Feb 2023 09:39:26 GMT

Thank you. It worked