Forum Discussion

Mic1979's avatar
Mic1979
Icon for Post Partisan rankPost 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

Omid_Motamedise's avatar
Omid_Motamedise
Icon for Super User rankSuper User
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

  • Mic1979's avatar
    Mic1979
    Icon for Post Partisan rankPost Partisan
    1 year ago

    Hello

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

     

    Thanks.