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.
when i did the remove row- remove duplicates , the earlist one will be kept,but i want to keep the latest one which is the one i need. how to achieve that?
Solved! Go to Solution.
@yanzhao_LBS
This document explains the issue and you can download the sample from it :
https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/
Hi @yanzhao_LBS
You need to sort in the wanted order before removing the action.
Also, you need to modify your m code to keep the sort order.
Please refer to the linked tutorial
https://www.youtube.com/watch?v=rqDdnNxSgHQ
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks for your response, but i cannot open the youtube ,can you give some doc link for the m code? as I have tried the sort,but it seems not work maybe need the 'm code ' you mentioned.
@yanzhao_LBS
This document explains the issue and you can download the sample from it :
https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/
Thanks for your help again ,it really works for me.
Happy to help 🙂
User | Count |
---|---|
88 | |
88 | |
74 | |
68 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |