Forum Discussion

Linnil's avatar
Linnil
Helper III
2 years ago
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 ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    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"}))

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago

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"}))

Linnil's avatar
Linnil
Helper III
2 years ago

This solution is perfect. It has an extra close bracket at the end of the code which I removed.

It worked perfectly for both odd and even countrows. Thanks Daniel!