Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

Dynamic 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...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    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

v-kathullac's avatar
v-kathullac
Community Support
1 year ago

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's avatar
    Mic1979
    Post Partisan
    1 year ago

    Hello v-kathullac 

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

    Accepted, many thanks for your great support.