Restart count in column

Question

I'm adding a column to a date table. &nbsp;The column needs to count to 20 by rows and restart.&nbsp;Example:&nbsp;Year &nbsp; &nbsp; Month &nbsp; &nbsp; Day &nbsp; &nbsp; BusPeriod2013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13 &nbsp; &nbsp; &nbsp; &nbsp;152013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14 &nbsp; &nbsp; &nbsp; &nbsp;162013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15 &nbsp; &nbsp; &nbsp; &nbsp;172013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16 &nbsp; &nbsp; &nbsp; &nbsp;182013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17 &nbsp; &nbsp; &nbsp; &nbsp;192013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18 &nbsp; &nbsp; &nbsp; &nbsp;202013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;19 &nbsp; &nbsp; &nbsp; &nbsp;12013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; 22013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21 &nbsp; &nbsp; &nbsp; &nbsp;32013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22 &nbsp; &nbsp; &nbsp; &nbsp;42013 &nbsp; &nbsp;06 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23 &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp;&nbsp;Any suggestion on how to go about this or if this is even possible?

arify · Accepted Answer

You can add an index column, and then transform that column into something like: Number.Mod([Index] + 1, 20)&nbsp;    #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 0, 1),
    #"Calculated Factorial" = Table.TransformColumns(#"Added Index",{{"Index", (index) =&gt; Number.Mod(index, 20) + 1, type number}})
in
    #"Calculated Factorial"

Forum Discussion

Restart count in column

2 Replies

Related content

Total Count in Column

Restart Capacity

Counting nulls

Column count duplicates

Count base from other column