Power Query: Way to add an index column that counts 1-4 and repeats that pattern?

[beaglesBuddy]

Is it possible to turn this
1
2
3
4
5
6
7
8
9
10...

into

1
2
3
4
1
2
3
4
1
2...

[MarvinP]

Hi BeaglesBuddy,

Please Login or Register  to view this content.

Add an Index column like normal and then add a custom column with a formula of:
=Number.Mod([Index],4) +1

https://msdn.microsoft.com/en-us/library/mt253344.aspx

I think this is what you want.

[beaglesBuddy]

Hi BeaglesBuddy,

Please Login or Register  to view this content.

Add an Index column like normal and then add a custom column with a formula of:
=Number.Mod([Index],4) +1

https://msdn.microsoft.com/en-us/library/mt253344.aspx

I think this is what you want.

Thank you so much MarvinP!