Power Query Trick: Dynamically Add Multiple Columns with List.Accumulate

In this Power Query tutorial, learn how to dynamically add multiple columns to a table using List.Accumulate — a powerful technique for looping through a list of column names and applying transformations without hardcoding. What you'll learn: How List.Accumulate works in Power Query Creating dynamic logic to add multiple columns Real-world use cases for scalable and reusable M code Perfect for intermediate to advanced Power BI and Excel users looking to streamline their queries and build flexible data models! Sample code and data included in the description. Like, comment, and subscribe for more Power Query and Power BI tips! #listaccumulate #powerquery #advancedfunctions 00:00 Introduction 00:47 Problem description 01:00 add manually 01:33 Using record-setting 03:01 Explaining List.Accumulate 06:58 Adding by List.Accumulate