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
I have a table which I'm trying to deduplicate using the group function, example of the data is below, simplified as there are alot of columns:
Source ID | AP Number | Date Created |
ID_123 | AP_987 | 01/01/2023 |
ID_123 | AP_654 | 01/02/2023 |
I've geoupled by the Source ID and used Max for the created date to get the most recent row, however when I expand the columns out again, it's pulling in all the dulicate rows again, rather than just the ones selected using the group function:
Is there way to only expand the rows which have then been fltered out using the group function as i's causing some issues with the reporting?
could you pls provide some sample data and expected output?
Proud to be a Super User!
User | Count |
---|---|
80 | |
78 | |
70 | |
70 | |
54 |
User | Count |
---|---|
107 | |
99 | |
88 | |
79 | |
67 |