Log In
Register
Home
September 9, 2020
Offline
Hi,
I have some initial data in an ASIS tab (in reality I have other columns that I have deleted for better readability). Some of these data are duplicates if I only take into account the columns: Date - H - M - TEL_CALLER - TEL_CALLED - DURATION - ANSWER.
Is it possible with Power Query to keep a single unique value corresponding to the earliest hour of the day?
In the ASIS sheet, I put the cell in red in the J column for those that need to be deleted. In the TOBE sheet, I put the result I am trying to obtain.
Thank you very much for the suggestions for a solution.
BR,
Lionel
November 8, 2013
Offline
Hi Lionel,
Steps to achieve that:
1. Sort datetime column Descending.
2. Edit this step in formula bar, wrap the existing code with Table.Buffer(yourstepformula)
3. Select all the columns that combined creates a unique key and from Home tab, Remove Rows-Remove Duplicates
1 Guest(s)
