I have some data, I want to delete the duplicates. This is easy in PowerQuery, however I want to delete both pairs (the original as well as the copy).
Please see attached how the data is (ignore calc column to quickly show duplicates) and how I want the data to look (did this by eye might be slightly wrong).
I deleted the calulated column.
=FILTER(Table4,COUNTIFS(Table4[Person],Table4[Person],Table4[Date],Table4[Date])=1) and format the date column as a date.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi that works thanks. I would be grateful if someone could provide a solution for this within Power Query.
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
This works thanks!Originally Posted by Olly
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks