Forum Discussion
Solved
Adding Recuring Index
Hi, is it possibel to replacate ; QUOTIENT(SEQUENCE(25,1,0,1),3)+1 in power Query without first addin an actual index ; so I've got ; Table.TransformColumns( Table.AddIndexColumn(So...
AFAIK, you can't do to directly get your desired output. But you could do something like:
= Table.AddIndexColumn(Source, "Index", 2/3,1/3) or = Table.AddIndexColumn(Source, "Index", 2/3,1/3, Int64.Type)and then, at the next step, change the data type to Int64.Type (whole number).
I would have thought is would do the conversion in the same step, but it does not.
