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 |
|---|---|
| 47 | |
| 35 | |
| 28 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 59 | |
| 58 | |
| 40 | |
| 22 | |
| 20 |