Forum Discussion

Frigge__'s avatar
Frigge__
Frequent Visitor
4 years ago
Solved

New column with specific number sequence

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

Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    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

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    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