Remove duplicates values based on multiple column with a condition in query editor

Hi@Mahi1989

You use Merge Queries function in Edit Queries.

You can try to do it follow my steps:

Step 1:

Duplicate the data table as below

Step 2:

Add index column for two table

Basic table start from 1 and increment is  1

Duplicate table start from 0 and increment is  1

Step 3:

Merge two table

Step 4:

Expand the table and apply &close

Step 5:

Add column

Column = IF(Table4[Time]=Table4[Added Index.Time]&&Table4[ID]=Table4[Added Index.ID]&&ABS(Table4[Time Spent]-Table4[Added Index.Time Spent])<1,1,2)

Step 6:

Filter the table

Here is demo ,please try it.

.PBIX https://www.dropbox.com/s/05w8ln994lz0kwu/Remove%20duplicates%20values%20based%20on%20multiple%20column%20with%20a%20condition%20in%20query%20editor.pbix?dl=0

EXCEL  https://www.dropbox.com/s/gle4648a4c81kro/example.xlsx?dl=0

Best Regards,

Lin