cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## I dont understand properly how List.Generate() works

``````let
my_list = List.Generate(
()=>[x=1], // Failr here with: "ExpressionError: The name 'x' wasn't recogniced. Make sure it's spelled correctly."
each [x]<101,
each [x=x+1],
each Number.Round(Number.RandomBetween(1,101),0)
)
in
my_list``````

Im just trying to create a list with length 100 filled with random numbers from 1 to 100. I wanna know why It doesn´t work.

this is the example from the docs I was looking at before:

``````List.Generate(
() => [x = 1, y = {}],
each [x] < 10,
each [x = List.Count([y]), y = [y] & {x}],
each [x]
)``````

You can check that example at (https://learn.microsoft.com/en-us/powerquery-m/list-generate)

1 ACCEPTED SOLUTION
Community Champion

@Anonymous The issue is at the third argument of List.Generate, when incrementing you need to consider that the current iterated value is a record so you need to use each [x= [x]+1 ]

Complete code:

``````let
my_list =
List.Generate (
() => [ x = 1 ],
each [x] < 101,
each [ x = [x] + 1 ],
each Number.Round ( Number.RandomBetween ( 1, 101 ), 0 )
)
in
my_list``````

If there isn't any other logic that you are going to use in List.Generate then you can also try List.Trasnform

``````=
List.Transform (
{ 1.. 100 },
each Number.Round ( Number.RandomBetween ( 1, 101 ), 0 )
)``````

2 REPLIES 2
Anonymous
Not applicable

Thanks a lot

Community Champion

@Anonymous The issue is at the third argument of List.Generate, when incrementing you need to consider that the current iterated value is a record so you need to use each [x= [x]+1 ]

Complete code:

``````let
my_list =
List.Generate (
() => [ x = 1 ],
each [x] < 101,
each [ x = [x] + 1 ],
each Number.Round ( Number.RandomBetween ( 1, 101 ), 0 )
)
in
my_list``````

If there isn't any other logic that you are going to use in List.Generate then you can also try List.Trasnform

``````=
List.Transform (
{ 1.. 100 },
each Number.Round ( Number.RandomBetween ( 1, 101 ), 0 )
)``````

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors