Need help keeping only the earliest or latest value and the rows, columns!

[k3rz0rg]

Hi everyone, 

I have this table below and wanted to filter out only the rows with earliest date per name or latest date per name rows. Could you please help me out to solve this problem?

(sample full data)

for example I need something like this below -

(if kept earliest dates only)             

 

   (if kept latest date only)

Can somebody tell how to do this in query editor and/or dax and/or M code?

Any hint/info is much appreciated!

Thanks,

K3

[CNENFRNL · Accepted solution]

Make it dynamic,

[amitchandak]

@k3rz0rg , refer if this can help

https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/