Power Query, Min and Max

[Anonymous]

Hi everyone, 

I need help getting the start job date and end job date in power query. I have a table like this right now:

What I want to do is to find the start and end date for each job based on the booking type (only take count of the "Chargeable" booking type.

The table that i want to have is this:

I need to do this in power query. would appreciate all the help i can get. Thanks alot

[amitchandak · Accepted solution]

@Anonymous , Duplicate the table, remove columns other the Jod, start and end date. Group and get min max start and end date

https://learn.microsoft.com/en-us/power-query/group-by

And merge them back with the original table joib job column

Merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query