79395839

Date: 2025-01-29 06:14:33
Score: 1
Natty:
Report link

Is this what you asked for

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Group = Table.Group(Source, {"Project#"}, {{"All", each _},{"Sugg_Start_Date", each List.Last(_[Sugg_Start])},{"First_Start_Date", each List.First(_[Sugg_Start])}}),
Expand = Table.ExpandTableColumn(Group, "All", {"Date", "Sugg_Start"}, {"Date", "Sugg_Start"}) 
in 
Expand

Or You can continue even without Expand Step if you need summarised result.

Reasons:
  • Has code block (-0.5):
  • Starts with a question (0.5): Is this
  • Low reputation (1):
Posted by: Raghu