Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
39 | |
21 | |
20 | |
13 | |
13 |