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.
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.
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
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 !!!
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.
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?
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
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]
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.
To learn more about the syntax of List.Generate, make sure to check out: powerquery.how/list-generate/
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.
Thanks Rick clarifying this in calm and easy way.
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.
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
I loved the calm and clear way you explained.
Excellent!
Thank you very much!
Almost gave up on PQ until I saw this - fantastic and very powerful! Thank you. Subscribed and looking forward to watching your videos. 👍👍
Awesome. And thank you, welcome aboard!👏
Extremely useful video. Thanks
Elegant, Elegant, Elegant! Simply magic, Rick! Thanks!
My pleasure suki 😁😁
Great video and explanation. Thank you.
Thank you Rick for explaining List.Generate function in depth....love it cheers
Glad to hear that, awesome!
Thank you for the blog and video, really appreciate it.
Nice tutorial
Thanks!
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 !!!
Glad to hear that. It's an advanced function but with some examples I hope you'll manage. 😁
Don't worry @@BIGorilla, the logic and the examples were clearly explained in your vid👍🏾
Thanks again!
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.
Simply great. Thansk for sharing
🙏 thank you!
Great one sir !!. Thank you
Thanks.
In the Fibonacci example, why are the x and y sometimes enclosed in [ ] and sometimes they are not?
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 :)
Хороший контент. Спасибо.
Awesome! Just found your channel and subscribed. Looking forward to learning more. Thumbs up!!
Thanks wayne! :)
Excellent 💯👍
This video is luxurious. Thank you very much. :-)
Only the best for you fajne!
Súper interesting your video. Thank you.
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?
Very nice und helpful content
Hope you find it useful!
In the factorial example shouldn't it be y = Number.Factorial ( x ) ---ie. not [x] otherwise the two lists are not the same
Thanks you
Genius 😮
Saved it !
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
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]
@@BIGorilla brilliant thanks for the explanation!
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.