Excel BI Power Query Challenge Workout 049

-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 49-
(Solution in any language also welcome for Power Query Challenges)

Generate the output table shown.
For a State group, From Date Time is the first date time and Time1, Time2 etc. are time in minutes between all time stamps appearing after that.
133 = Diff between 1/4/23 17:41 & 1/4/23 15:29
1045 = Diff between 1/5/23 11:06 & 1/4/23 17:41
For Power Query solutions, this has to be dynamic. Hence for A, if 5 rows appear in place 4, then Time 8 and Time 9 also should be shown.

Download Practice File - https://lnkd.in/dWtZkU4M

(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)

#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge

Excel BI’s LinkedIn Post