Forum Discussion
Solved
remove distinct values from row within a column
I am trying to remove repeated values from a column that has comma seperated values (Ex, 1,3,4,6,7,9,9,9,9) should return (1,3,4,5,6,9) I found a match for my issue on stack overflow, which wor...
jbbcormed Try adding a custom column like this:
=Text.Combine(List.Distinct(Text.Split([YOUR COLUMN NAME], ", ")),", ")
You can then remove the original column.
jbbcormed Try adding a custom column like this:
=Text.Combine(List.Distinct(Text.Split([YOUR COLUMN NAME], ", ")),", ")
You can then remove the original column.
Oh my gosh, I don't know why that threw me for a loop, worked like a champ, this is like when I realize I should be doing a calculated column instead of a measure in DAX. "When it no worky, consider you are doing it in the wrong place" haha
Edit: And THANK YOU!
