M Lanuage code to create index values for each field value

Question

Hi,&nbsp;I am trying to write a script that will generate an index number for each value in the "Entity" field. Here is a sample of the output I want to create. I have tried using the Group function in combination with the AddIndexColumn function but I cannot get them to produce this outcome. Any suggestions please?&nbsp;&nbsp;&nbsp;

wdx223_daniel · Accepted Answer

=Table.Combine(Table.Group(PreviousStepName,"Entity",{"n",each Table.AddIndexColumn(_,"Index",1)})[n])

Forum Discussion

M Lanuage code to create index values for each field value

1 Reply

Related content

Create Measure to Return Highest Value

Creating Relationships with duplicative values

Creating relationships

Creating ICMs via Activator

Creating a record from list values