Skip to content

Details

Power Query allows you to do lots of useful things with just the UI. But for operations where references to previous results have to be made, you need to resort to recursive functions that – so far – require a lot of manually-written code. Think about Bill-of-materials, paginating web queries, dynamically solving hierarchical structures, running totals, dynamically adding columns, and much more.

In this session, Imke will present a new technique that largely bypasses the need for coding and allows you to click through the UI as before. Learn how easy it can be to design all kinds of recursive tasks using Lists, Generate or List, Accumulate in Power Query.

Link to the event:
https://teams.microsoft.com/l/meetup-join/19%3ameeting_MzdmZjdmZDAtYzE5My00MDhhLTk5NjEtNGI3MTQwNmIxMTk1%40thread.v2/0?context=%7b%22Tid%22%3a%22cf36141c-ddd7-45a7-b073-111f66d0b30c%22%2c%22Oid%22%3a%22f1a81ceb-bc1b-4a5f-bb89-060cdad7e922%22%7d

You may also like