Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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(_, ",")), ",")})
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.