New column with specific number sequence

[Frigge__]

Hi, 

I do a power query to a local database, and now I need to add a new column with a cyclic number sequence. I need to do this in Power Bi.

The column should start with 1 and go up to 93 and then start over. 

Please advise.

BR

[Frigge__]

Works great @BA_Pete !

Thanks!

[BA_Pete · Accepted solution]

Hi @Frigge__ ,

First, go to the Add Column tab in Power Query > Index Column > From 0.

Then add another custom column like this:

Number.Mod([Index], 93) + 1

Pete