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 pl...
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.
HotChilli
Community Champion
Community ChampionA 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