For-Next Loops in Power Query: Using List.Accumulate for repetitive transformation tasks

Описание: In this video, we'll dive into the powerful List.Accumulate function in Power Query, showing you how to create loops (for next) and perform complex data transformations. Whether you're looking to iterate over lists or perform cumulative calculations, List.Accumulate is your go-to tool. Follow along as we break down the steps and provide practical examples to help you harness the full potential of this function in your data projects.

00:00 Syntax of List.Accumulate
00:30 List.Accumulate example
03:25 Using List.Accumulate two add several columns once
07:56 Using List.Accumulate to transform several columns once