Mastering recursive operations the low code no code way in Power Query by Imke Feldmann - STR PPUG скачать в хорошем качестве

Mastering recursive operations the low code no code way in Power Query by Imke Feldmann - STR PPUG

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.