Forum Discussion

RupertBear's avatar
RupertBear
Regular Visitor
7 years ago
Solved

Repeating Index Colum over Values 1-n

Hi,   I am struggling to implement a new index column that starts from one, counts up to 44 and then repeats this until the end of my data ( the number of rows varies depending on the source).   ...
Need Help
Tips and Tricks
Tutorial Requests
  • PradipMCT's avatar
    PradipMCT
    7 years ago

    Hi 

     

    You can create the index column first. 

     

    Power Query --> Add Column --> Index column

     

    Now create a modulo column which you'll find under 

     

    Power Query --> Add column --> Standard --> Modulo 

    Enter the number 44 as mentioned by you. 

     

    You are sorted.

     

    If this is the solution then please mark it as a solution while responding. 

     

    Thanks.

    Pradip Pardeshi (Microsoft Certified Trainer)

PradipMCT's avatar
PradipMCT
Resolver II
7 years ago

Hi 

 

You can create the index column first. 

 

Power Query --> Add Column --> Index column

 

Now create a modulo column which you'll find under 

 

Power Query --> Add column --> Standard --> Modulo 

Enter the number 44 as mentioned by you. 

 

You are sorted.

 

If this is the solution then please mark it as a solution while responding. 

 

Thanks.

Pradip Pardeshi (Microsoft Certified Trainer)