Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I've run into an issue where I need to remove duplicates keys, but keep the row information.
As you'll see below, I have a duplicate value for DateLocation key 62446, because it has two different survey types. I don't care about survey type, so I need to roll up that info into a single entry (i.e. a single 62446 entry with 2 surveys, 2 promoters, etc.).
Any assistance?
Solved! Go to Solution.
Hi,
Select the DateKey and DateLocation columns, right click and select Group. Now select the aggregation function which you want for each column.
Hope this helps.
Hi,
Select the DateKey and DateLocation columns, right click and select Group. Now select the aggregation function which you want for each column.
Hope this helps.
Perfect, thank you. I've always used Group By to find duplicates, but never to merge them before.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |