Forum Discussion
Filtering Duplicate Data
Anonymous in power query, select all columns and then select remove duplicates.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Super UserAnonymous in power query, select all columns and then select remove duplicates.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k thank you for your support. Unfortunately, I am still getting the same results. My thoughts are that power query is still keeping the duplicate values because the timestamp on the duplicates are unique (please look at my sample table 1 / transaction_id = 1).
Any other thoughts on how you would approach removing duplicates that have unique datetime stamps?
parry2k After reworking your suggestion, it ultimately worked out. The only difference with your solution and mine is that I selected the individual column to remove the duplicates. My initial concern was that it was going to remove stores or other legitimate duplicates.
Thank you so much for your support!