Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Guys,
I want to remove duplicates for row 'Item'. and keep the row with the earliest date based on row 'Transaction Date'.
So in the picture showed below it should result for example with item no. 0000.2121 only 1 row with transaction date 13/07/2023.
Can someone help me figure this out?
Thanks!
In Power Query, select all columns except date, do a 'Group By' and select the Min date as an aggregation. This will work if the rows are identical except for the Transaction date
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |