Forum Discussion
Index column based on values
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
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})
2 Replies
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})
Thank you very much, it worked and helped me a lot.
