Forum Discussion

ratercero's avatar
ratercero
Icon for Helper III rankHelper III
8 years ago

On Power Query Editor, how to filter rows with the earliest date each name aprears

Hello I merged 4 tables, that have duplicate values, I want to keep only the one that has the earliest date for each "Lote" (ignoring case), how can I fix this? The code I have removes duplicates but...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

ratercero

 

OK, please look the image.

 

 

Regards

 

Victor

Lima - Peru

ratercero's avatar
ratercero
Icon for Helper III rankHelper III
8 years ago

Vvelarde,

 

what this does, is that shows only dates on the listings, causing even more duplicates on my data as in you date those dates do no duplicate it you do not see it on your query, please review my data sample once ome maybe I made a mistake while replicating what is on the image.

 

Data Sample