Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
41 | |
24 | |
22 | |
20 | |
13 |
User | Count |
---|---|
159 | |
61 | |
60 | |
28 | |
20 |