Need to remove all duplicate rows in power query based on date and barcode id

[nagaraj007]

Hello All,

As shown below, i have got requirement to count the footfall, however in one day there will be multiple entries from the same barcode id.

I need to remove this in power query and keep only 1 data which would be MIN date of that particular day for that particular barcode id.

Please help me 

[Ahmedx · Accepted solution]

to know how to do this watch my video

https://1drv.ms/v/s!AiUZ0Ws7G26RjEBkV0C3S3OjVGtU?e=uPN2ca

{"tmp", (x)=>Table.Max(x,{"ID",{"Enter time",Order.Descending}})