Date row assistance

Hi ChristoAClark ,

Here is my sample data:
start dataend data

Add an Index column first:

Index = RANKX(ALL('table'), 'table'[start date], ,ASC, Dense)

Then add a column as a Tag:

Tag = var a=[end date]+1
var b=[Index]
var c=LOOKUPVALUE('table'[start date],'table'[Index],[Index]+1)
return IF(a=c,1,0)

Use this DAX to create a calculated column for end date:

EndDate_range = IF([Tag]=0,[end date],MINX(FILTER('table',[Tag]=0&&[Index]>EARLIER('table'[Index])),[end date]))

And use this DAX to create a calculated column for start date:

StartDate_range = MINX(FILTER('table',[EndDate_range]=EARLIER('table'[EndDate_range])),[start date])

The final output is as below:

In the table visual:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Holy cow! You are my new hero. THis works exactly as I hoped. Thanks so much.