Hi, i'm relatively new to Power Query and have hit an obstacle which i can't seem to get my head around.
I havea list of records for a client which denotes how many services they've had over a period. If additional lines are added within 28 days of the previous it would be considered an 'existing' line to a package of care. I have manged to identify these...but what I need to do now is further group the first instance of a 'new' package with subsequent 'existing' lines for each client...creating a [package_id] in the process. Once I have each line assigned to a [package_id] i then need to determine the [start date] and [end date] for that [package_id] (see example in link below)
I'm hoping someone can help me :)