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?