Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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})
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.