Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I want to remove duplicates based on the first column, but keep the row with the highest price based on the last column. So in the image item 0000.9166 should keep the row with price 11.85
Thanks
Solved! Go to Solution.
In Power Query Editor, do a group on item and create a new column with Max on Price.
Below is the data
after applying below grouping
This is the required result
In Power Query Editor, do a group on item and create a new column with Max on Price.
Below is the data
after applying below grouping
This is the required result
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |