Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors