Power Query Custom Index Column

Hi, I wanted to add a custom index so each 111, 222, 333, 444, etc. or 123, 123, 123, 123, etc ,

So in excel either

QUOTIENT(SEQUENCE(25,,0,1),3)+1

or MOD(SEQUENCE(25,,0,1),3)+1
others are available 樂

so I though I could use the index column and just increase by a fraction and round; but the problem is

1.8 + 0.2 is not 2, it's 1.9999999999999998

so it throws everything out, so without grouping or creating a list in generate and then putting together is there another approach or way around this?

One quick fix I've since found is to add a small number so ;

Please Login or Register  to view this content.

Richard.

Just use a normal index starting at 1 then something like:

Please Login or Register  to view this content.