Forum Discussion
Repeat steps multiple times over the same table
Hi all! I'm a little stuck whit power Query, I'm trying to repeat multiple steps over the same table. My input(Source) looks like this: Date Index Volume 9/01 1 1100 9/02 2 1...
= #table(Table.ColumnNames(PreviousStepName),List.Accumulate(Table.ToRows(PreviousStepName),{{},{}},(x,y)=>{x{0}&{{y{0},y{1},y{2}??List.Average(List.LastN(x{1},4))}},x{1}&{y{2}}}){0})