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

Frigge__'s avatar
Frigge__
Frequent Visitor
4 years ago

Works great BA_Pete !

Thanks!