cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dblank1974
Regular Visitor

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;

 

Snip 1.png

 

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;

 

Code.png

 

There are no syntax errors but when I run it I get the following error

 

Code_error.png

 

What am I doing wrong?  Any pointers would be greatly appreciated.

1 ACCEPTED SOLUTION
dblank1974
Regular Visitor

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.

 

fix action.png

View solution in original post

2 REPLIES 2
rashidkhanrk06
Regular Visitor

Hello there

You should try this 

Table.TransformColumns( Source , {"Plugin Name", each Text.Combine(List.Distinct( Text.Split(_, ",")), ",")})

dblank1974
Regular Visitor

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.

 

fix action.png

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors