vendredi 3 février 2017

Power query: add column to lookup minimum date if criteria fulfilled

I am new to power query. Let's say I have two columns: ID and date. I want to add a third column Earliest Date. This column should look up the earliest or minimum date across all the data that matches the ID in that row. It would produce the below. I have a lot of data so need to use power query. How do I write the formula?

ID  Date    Earliest Date
501 01/01/2017  01/08/2015
203 08/06/2015  08/06/2015
304 01/04/2014  01/04/2014
501 01/01/2016  01/08/2015
201 01/02/2015  01/02/2015
501 01/08/2015  01/08/2015

Aucun commentaire:

Enregistrer un commentaire