Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi, as in the picture below you can see i have duplicate rows. I want to remove duplicate rows based on the whole row and not only based on one column.
How can i do that?
I think you want to keep the most recent entry? Here you go https://www.youtube.com/watch?v=hidJ5T_DYQ0&list=LL&index=79
credit to Curbal
| User | Count |
|---|---|
| 60 | |
| 46 | |
| 32 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 82 | |
| 68 | |
| 43 | |
| 26 | |
| 25 |