Dynamic List.Repeat

[Mic1979]

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 this change dynamic based on the values I get in the Column Rows To ShiftDown

ColToMove = HeadersToShift,
MovedCol = List.Repeat({null},Rows_To_ShiftDown)&ColToMove

But I got this error:

Expression.Error: We cannot convert a value of type Table to type Number.

Could you help?

Thanks.

[v-kathullac]

Hi @Mic1979 ,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,

Chaithanya

[Mic1979]

Hello @v-kathullac 

sorry for the delay, I just had the opportunity to test the solution.

Accepted, many thanks for your great support.

[Omid_Motamedise · Accepted solution]

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

[Mic1979]

Hello

How to start this repetition from the second element of the column and not from the first?

Thanks.

[Mic1979]

I did not get your answer.

I knew the reason, but I would like to understand how to fix the issue.

I am not so familiar with PQ unfortunately. 🙂

Thanks a lot.

[ZhangKun]

To 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.