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

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...

Originally Posted by MarvinP

Hi BeaglesBuddy,

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Team", type text}, {"Team Data", type text}}),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 0, 1),
    #"Added Custom" = Table.AddColumn(#"Added Index", "MOD4", each Number.Mod([Index],4)+1)
in
    #"Added Custom"

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!