Forum Discussion
Need help to Remove duplicate duplicate in same cells leaving distinct values
I am new to power BI and the M code. I need help removing duplicates within a cell but keeping the distinct values. Below is the sample table I am trying this on. I already grouped on a single column and extracted the data I wanted;
As you can see from the highlights I only want one test 3 in each of these examples. Below is the code I am trying with the advanced editor;
There are no syntax errors but when I run it I get the following error
What am I doing wrong? Any pointers would be greatly appreciated.
well, I guess it only took me to spell out my problem on this forum to see where I was messing up. I soolved my own problem. Below was the correct code if anyone is interested. The highlight is what changed.
2 Replies
well, I guess it only took me to spell out my problem on this forum to see where I was messing up. I soolved my own problem. Below was the correct code if anyone is interested. The highlight is what changed.
Hello there
You should try this
Table.TransformColumns( Source , {"Plugin Name", each Text.Combine(List.Distinct( Text.Split(_, ",")), ",")})