Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.