Forum Discussion
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...
This does not work as I intend, due to the values in the other columns are not the same, keeps duplicate "lote". I need something that determines the minimum date for each "lote" and keep that row only.
Your data is like this:
Lote OTHERCOL1 OTHERCOL2 Date
AAA1 FFFF GGGGG 15/02/17
AAA2 GGFFD RRRRR 11/02/17
AAA1 RERER GGGF 03/02/17
AAA2 RRR AAASD 15/02/17
And you want to keep this:
Lote OTHERCOL1 OTHERCOL2 Date
AAA1 RERER GGGF 03/02/17
AAA2 GGFFD RRRRR 11/02/17
Its ok this.