Add new custom column starting from 1 for each new Pi

[Anonymous]

Hello I have 2 columns (PI and Sprint) and I need to add the 3rd column below but it doesn't work with "add column from example" and I can't find a way to do it with "Add custom column". Could you please give me a hand? The expected column should generate a new serie starting from 1 for each new Pi.

Pi	Sprint	ExpectedColumn
0	1	1
0	2	2
0	3	3
0	4	4
1	5	1
1	6	2
1	7	3
1	8	4
1	9	5
2	10	1
2	11	2
2	12	3

Thank you

DM

[HotChilli · Accepted solution]

A good case for grouping then adding an index per group.

So Group By 'Pi' with All Rows as the aggregation (call it "all").

Then Add a custom column:

Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([all], "Count",1,1))

remove the Pi and 'all' columns and expand.

Let me know how you get on.

[Anonymous]

It worked! Thank you very much @HotChilli !!! Made my day.

Best regards