Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
I have a column like this:
Messages |
Hi there |
What up |
What up |
My Name is John |
What Up |
Cool Story |
I want:
Messages |
Hi there |
What Up |
My Name is John |
Cool Story |
So I want to delete the duplicates in one column (not row) and let one of them stay. Is this possible?
Thank you guys.
Solved! Go to Solution.
@Anonymous , You can display this column in visual that will show only unique value.
Select this column in power query, right click and remove duplicate that will remove the rows for duplicate value for this column
Or create a new table in DAX
distinct(Table[COlumn])
@Anonymous , You can display this column in visual that will show only unique value.
Select this column in power query, right click and remove duplicate that will remove the rows for duplicate value for this column
Or create a new table in DAX
distinct(Table[COlumn])
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |