Forum Discussion
Mic1979
Post Partisan
Post PartisanDynamic List.Repeat
Dear all, I have the following set of data: I used the following formula to get: ColToMove = HeadersToShift, MovedCol = List.Repeat({null},2)&ColToMove I tried to make th...
because Rows_To_ShiftDown is a table, not a single number — but List.Repeat expects a number as its second argument (how many times to repeat).
maybe you can use the following formula instead
ShiftCount = Rows_To_ShiftDown{0}[YourColumnName],
MovedCol = List.Repeat({null}, ShiftCount) & ColToMove
ZhangKun
Super User
Super UserTo just answer your question: the error is because Rows_To_ShiftDown is a table, not a number.
Perhaps you could complete your question to get better suggestions.