List.Generate in Power Query - Tutorial with Easy Examples

This video explains how List.Generate works in Power Query. You will see examples for basic number sequences, examples involving multiple variables and lastly series returning text values.

WRITTEN BLOGPOST:

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

Chapters:
00:00 Introduction
00:48 List.Generate Basic Number Series
08:26 List.Generate Fibonacci Sequence
14:14 List.Generate Sequence with Factorials
17:41 List.Generate Return Text Values

#ListGenerate #PowerQuery #BIGorilla

[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.

[vaibhavsrivastava]

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.

[joaorataoo]

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

[flamethrower]

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

[vashisht]

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

[suki]

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

[JanBolhuis]

Great video and explanation. Thank you.

[stewart]

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

[wayneedmondson]

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

[odel_leal]

Súper interesting your video. Thank you.

[tonyagamata]

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 !!!

[fajnefajne]

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

[rajanidumpa]

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.

[iankr]

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

[teaking]

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

[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.

[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

[Fatemeh-tuvc]

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