Simple List.Generate in Power Query: Master the "Do Until Loop" Easily

Описание: A simple example to learn how to use List.Generate for recursive calculations: We dive deep into the power of List.Generate in Power Query, using a fun Excel BI challenge to illustrate its automation capabilities. Watch as we repeatedly divide a number and round up the result, showcasing how List.Generate can handle tasks where the number of iterations is unknown. Plus, the task itself is simple, making it a great way to master List.Generate's capabilities in Power Query:

Divide the numbers given in column A by 7 and round it up.
Divide the result by 7 and round it up. Continue till you get 1.
Get the sum of all the numbers after roundup.

👉 List.Generate is a great function. ❤
👉 Once understood you can use if also for more complex tasks.
For example Grouped Running Totals:    • Power Query: The EASIEST Running Total & C...  

🔍 *What You'll Learn:* - Step-by-step instructions on using List.Generate - Tips and tricks to enhance your Power Query skills

Here is the link to the Power Query challenge itself: https://lnkd.in/eTxPnvvB

#powerquery #excel #powerbi #dataanalysis #tutorial
Like 👍, comment 💬, and share ➦ with fellow data enthusiasts to spread the knowledge!


Ready to become a Power Query master? Join me, Matthias Friedmann, and learn advanced data techniques and solve complex Power Query challenges with ease:
🔔 Subscribe for more expert Power Query tutorials:    / @matthiasfriedmann  
💡 Connect with me on LinkedIn to get more insights, tips & tricks:   / matthiasfriedmann