Forum Discussion
Solved
Create a Column which labels table rows as Section 1, Section 2, 3, 4 according to number of rows
Hi - I have a table with a variable amount of rows. Whenever the data is refreshed (once a week) it changes. I would like to count all the rows and then divide those rows into 4 sections, more of ...
please use my code as a new step, instead of puting it in the add column function.
click the "fx" label beside the formula edit bar, then copy code into formula area
=let
AAA=Table.RowCount(#"Added Index")
in Table.FromColumns(Table.ToColumns(#"Added Index")&{List.Transform({0..AAA-1},each "Section "&Text.From(Number.IntegerDivide(_,Number.RoundUp(AAA/4))+1))},Table.ColumnNames(#"Added Index")&{"Section"}))
the code will not change the row number of your data, it just add a new column
Table.ToColumns(YourData)&{NewColumn}, this will not delete any rows.
try to check, is there some steps filter out something.
Hi Daniel
OK - yes - it is all working perfectly! Thanks for your patience and thanks for such a great solution.
All the best
Linnil