The (M)agic of List.Generate in Power Query | Rick de Groot

[@Computergaga]

Get involved and attend future London Excel Meetups - www.meetup.com/London-Excel-Meetup-Group/

[@BIGorilla]

Thanks for having me on the show Alan!

[@Computergaga]

You're welcome, Rick. Thank you for your time and excellent presentation.

[@williamarthur4801]

Brilliant intro to list generate, I find it one of the more complex m functions, especially when working with records, thank you to Rick and all involved.

[@Computergaga]

You're very welcome! Thank you, William.

[@ExcelOffTheGrid]

Great session. Lots to learn and apply. ⭐️⭐️⭐️⭐️⭐️

[@Computergaga]

Thanks, Mark.

[@BIGorilla]

Great mark! Thanks 🙏

[@NMVJ]

Thanks Rick for sharing your knowledge on List.generate :)

[@NMVJ]

Hi Alan...Please do guide me to more content of Topics like this. Thanks for these Videos.

[@kebincui]

Excellent session👍

[@Computergaga]

Thanks Kebin

[@martyc5674]

Great video Rick well done and thanks Alan/Tea for organizing.

[@Computergaga]

No worries, Martin. Thank you.

[@BIGorilla]

Thanks Martin, glad you liked it!

[@billgillaspey9036]

Great video, great training. Thank You !

[@Computergaga]

Thanks, Bill.

[@FRANKWHITE1996]

great content thanks for sharing

[@Computergaga]

Glad you enjoyed it.

[@diegolozano2397]

Thansk😁

[@Computergaga]

👍😊

[@subhajitmoyra6275]

Thanks for such an informative video! I went from "wtf" to "Wow, I actually made a soft!" in about an hour (I had to keep stopping and

[@Computergaga]

😀

[@BIGorilla]

Great!

[@rrrraaaacccc80]

💯👍

[@billgillaspey9036]

The "running total" code is a nice application of List.Generate ! BTW: How does this compare with DAX measures that might accomplish the same thing. Just curious.

[@Computergaga]

I think it depends on the application Bill. I believe the List.Generate performs better, but what are you using it for? Using DAX would make the measure available in visuals and other measures. A measure and a field are not exactly the same.

[@BIGorilla]

Accomplishing running totals with DAX is much easier. The code is shorter and less complex to understand. The application however is different. If you have a use case where having a running total makes sense to have in your data model, go ahead and prep it in sql or power query. You’ll be able to leverage better compression and memory usage. But if you need flexibility to show it on different granularities (product, customer, store, by week etc) or in different time periods, DAX offers the flexibility to address each level.

[@billgillaspey9036]

@@Computergaga thanks for the reply

[@billgillaspey9036]

@@BIGorilla thanks for the info!