List.Generate fixed number of items

[mgrayTCB]

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 _

)

[AlienSx · Accepted solution]

12 items equal to [Amt] field???

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