Forum Discussion

mgrayTCB's avatar
mgrayTCB
Icon for Helper IV rankHelper IV
3 years ago
Solved

List.Generate fixed number of items

I am trying to generate a list in PQ based on a filed value. I always want the list to be the same number of items. So for earch record in the table I want a list 12 items long. The value of all 12 items would be equal to the Amount Field on the record.

 

I can get the right value in the list but I cant figure out how to limit the list to just 12 items. How do I add a counter or something to limt it to 12 times?

 

List.Generate(

() => [Amt], // the starting value
each _ > 0, // as long as the value greater than 0
each _

)

  • 12 items equal to [Amt] field???

    each List.Repeat({[Amt]}, 12)

1 Reply

  • 12 items equal to [Amt] field???

    each List.Repeat({[Amt]}, 12)