Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
92 | |
86 | |
78 | |
72 | |
65 |
User | Count |
---|---|
115 | |
107 | |
86 | |
65 | |
64 |