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 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
86 | |
68 | |
64 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |