Forum Discussion
Add new custom column starting from 1 for each new Pi
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
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.
2 Replies
- HotChilli
Community Champion
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.
It worked! Thank you very much HotChilli !!! Made my day.
Best regards