Date questions controle end date

In Power Query, try the following code

•  Group by ID
• Add a column to each subgroup consisting of the date column altered by
  • Removing the first entry
  • Duplicating the last entry

let

//change next line to reflect actual data source
    Source = Excel.CurrentWorkbook(){[Name="Table7"]}[Content],

    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Date", type date}}),

//Group by ID
//Then shift the date column up one (delete first entry,
//  adding the "last" date to the bottom
    #"Grouped Rows" = Table.Group(#"Changed Type", {"ID"}, {
        {"End", each
            Table.FromColumns(
                Table.ToColumns(_) &
                {List.RemoveFirstN([Date],1) & {List.Last([Date])}},
                {"ID","Date","End"}),
                type table[ID=Int64.Type,Date=date, End=date]}
    }),
    #"Expanded End" = Table.ExpandTableColumn(#"Grouped Rows", "End", {"Date", "End"})
        
        
in
    #"Expanded End"

Results from your Data above