Forum Discussion
Power Query, Min and Max
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
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
1 Reply
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