Index column based on values

[Tillyz]

Hi everyone,

I would like to create an index column in power query/dataflow based on different projects. 

But now query only gives me this:

Is that possible to achieve the first table?

Appreciate any helps. 

Regards,

Tilly

[wdx223_Daniel · Accepted solution]

NewStep=Table.FromRecords(List.Accumulate(Table.ToRecords(PreviousStepName),{{},[]},(x,y)=>let a=Record.FieldOrDefault(x{1},y[Project Name],Record.FieldCount(x{1})+1)+1/100 in {x{0}&{y&[Index=a]},x{1}&Record.AddField([],y[Project Name],a)}){0})

[Tillyz]

Thank you very much, it worked and helped me a lot.