Power query: How to join record by dates

[ablattmann]

I would like to group the occurences where the start date and end date are continous. Any idea how to do this in power query ?

Thanks in advance.
Best Regards,
Alain

 

[johnny51981]

Hi @ablattmann
It appears that you are wanting to do a Group By. In your query editor, in the Transform tab, select Group By. Select the Advance radial.

Then have your Groupings be Matricule and Code (click "Add Grouping" so that it brings up a second drop down box for your Code)
And your Aggregations create your new columns where your new Start Date is a Min of your Start Date and your new End Date is a Max of your End Date

 

[ablattmann]

Thanks for your reply. If I understood correctly I should do this:

However If I do this I get this results:

Which unfortunately is not what i would like to get in my exemple above.

Best Regards,
Alain

 

[johnny51981]

Can you provide a bit more detail on what you are looking to achieve in your Expected Results? What decides the entries that are kept?

 

[ablattmann]