List.Generate in Power Query - Tutorial with Easy Examples

[@BIGorilla]

To learn more about the syntax of List.Generate, make sure to check out: powerquery.how/list-generate/

[@RobertoStaltari]

This is the one and only video where you can understand List.Generate. Microsoft documentation is surprisingly bare, inadequate to explain this complex and powerful function. Thanks Rick.

[@vaibhavsrivastava7196]

Thanks Rick clarifying this in calm and easy way.

[@CAKimberlyLewis]

Truly appreciate the written blog post partner to the video! Truly helpful to have them both! I know the written posts take so much time, but they are very appreciated.

[@BIGorilla]

Thank you so much Kimberly for your kind words. I know this function was a tough cooky for me to understand and hopefully my research gives you a kickstart. Keep crushing it, Rick

[@joaorataoo]

I loved the calm and clear way you explained. Excellent! Thank you very much!

[@JanBolhuis]

Great video and explanation. Thank you.

[@samirvaghasiya9918]

Extremely useful video. Thanks

[@rajanidumpa9834]

Thanks for sharing the video. I have one question though, I am unable to schedule refresh with the current code. Can you please help me here, on what do I change to schedule refresh on service.

[@ThepExcel]

Nice tutorial

[@BIGorilla]

Thanks!

[@vashisht1]

Thank you Rick for explaining List.Generate function in depth....love it cheers

[@BIGorilla]

Glad to hear that, awesome!

[@flamethrower5320]

Thank you for the blog and video, really appreciate it.

[@suki9860]

Elegant, Elegant, Elegant! Simply magic, Rick! Thanks!

[@BIGorilla]

My pleasure suki 😁😁

[@iankr]

Thanks. In the Fibonacci example, why are the x and y sometimes enclosed in [ ] and sometimes they are not?

[@BIGorilla]

In one part it's the opening of a record and in the other part the brackets reference the variable that was defined earlier. Hope that helps :)

[@stewart5136]

Almost gave up on PQ until I saw this - fantastic and very powerful! Thank you. Subscribed and looking forward to watching your videos. 👍👍

[@BIGorilla]

Awesome. And thank you, welcome aboard!👏

[@tonyagamata2874]

Thanks! I'm still learning PBI and currently having a roadblock on a report I'm working on. I'll definitely utilise this function cos it might get me somewhere and see how it goes. Muchas gracias !!!

[@BIGorilla]

Glad to hear that. It's an advanced function but with some examples I hope you'll manage. 😁

[@tonyagamata2874]

Don't worry @@BIGorilla, the logic and the examples were clearly explained in your vid👍🏾 Thanks again!

[@isidrebague3659]

Simply great. Thansk for sharing

[@BIGorilla]

🙏 thank you!

[@vinayak254]

Great one sir !!. Thank you

[@Fatemeh-tu1vc]

Hi there, I used your instruction but once I apply the changes it takes 20 hrs. so data be loaded and I have 1200000 rows of data. can you please help me out find the problem?

[@rrrraaaacccc80]

Excellent 💯👍

[@bn_ln]

In the factorial example shouldn't it be y = Number.Factorial ( x ) ---ie. not [x] otherwise the two lists are not the same

[@wayneedmondson1065]

Awesome! Just found your channel and subscribed. Looking forward to learning more. Thumbs up!!

[@BIGorilla]

Thanks wayne! :)

[@ПавелЛинев-ч7м]

Хороший контент. Спасибо.

[@karimallahwala7022]

Very nice und helpful content

[@BIGorilla]

Hope you find it useful!

[@odel_leal]

Súper interesting your video. Thank you.

[@DinoAMAntunes]

Hello Good Night, Can you share a video with a table with 100 rows and 3 columns for example, and you want to split that table in 10 sub-tables, automatically, and 10 new excel sheets. tks in advance.

[@fajnefajne4339]

This video is luxurious. Thank you very much. :-)

[@BIGorilla]

Only the best for you fajne!

[@fahadea1]

Genius 😮

[@teaking1981]

Amazing video showing list generate its a function that isnt well documented so appreciate the video, on the part with factorial numbers should the selector for "Y" also be Y=[X]=1 as on that loop it would have been using X as the initial value so you get the duplicate line with 1? Im only asking to try to understand the function :) I really enjoyed the video

[@BIGorilla]

Hi Glyn, That's a good point. You could improve the code by starting with Y = 1, and starting with x = 2. This would mean that the first returned result is Y = 1. The next value then is the Number.Factorial( 2), so for X = 2. With that change, the result would be a list showing: {1, 2, 6, 24, 120, 720, 5040, 40320, 362880 } Or the full code: = List.Generate( () => [x = 2, y = 1], // x = increasing series, y = factorial each [x]

[@teaking1981]

@@BIGorilla brilliant thanks for the explanation!

[@nguyenchitrung8809]

Thanks you

[@julie_chen]

Saved it !