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).
Go to Solution.
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.
Pradip Pardeshi (Microsoft Certified Trainer)
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.