Forum Discussion
Dicken
Post Prodigy
Post ProdigyAdding 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.
DickenPost Prodigy
Post ProdigyThanks I'll leave it open, never knwo someone might have ideas. I'm still not sure why
and increment of 1/3 works but Number.IntegerDivide( 1,3) just results in zero's.