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.
Hello guys, my problem is the one in the subject, it looks like simple but i can't find a solution, so in my table if I have a duplicate line they are errors and I would like to eliminate both, how can I do that in power query? Sometimes the value appears more than two times.
Fruits |
Orange |
Banana |
Apple |
Orange |
Orange |
Melon |
It should be like that
Fruits |
Banana |
Apple |
Melon |
Solved! Go to Solution.
Hi,
1--Do a Merge with the Same Table
Fruits With Fruits
2 --When Expand the Table Select Aggregate - Count of Fruits
3--Filter This New Column is equal to 1.
Regards
Victor
Hi,
1--Do a Merge with the Same Table
Fruits With Fruits
2 --When Expand the Table Select Aggregate - Count of Fruits
3--Filter This New Column is equal to 1.
Regards
Victor
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.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |