List.Accumulate Case Study in Power Query

How to use List.Accumulate in Power Query / Power Query M Language

In this video, we will learn how to dynamically add multiple columns to our data using the List.Accumulate function. Often, we require adding columns to our data based on certain conditions, but manual addition can be time-consuming and non-flexible.

With the List.Accumulate function, we can make the column addition process dynamic, expanding the number of columns based on the conditions. By the end of this tutorial, you will have a clear understanding of how to create dynamic column addition using List.Accumulate in Power Query, making your data processing more efficient and adaptable.
#PowerQueryTutorial #mlanguage #datacleaning

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[Lyriks_]

Every body is praising chandeep for it's excel skill (which he deserves), but i can't help to outline, the quality of the video production, it looks like hollywood for excel geeks 🤓
Good job man ! All the best for your course !

[wildecorrea]

The way you explained the video, first presenting the problem; then, the method, the function and, finally, the solution, was very good, very educational. I learn a lot from your videos! Success! Hi from Brasil 🇧🇷! God bless you!

[tremolony]

I love your videos bro. Most other people I see covering DAX or Power M have literally no idea what they are talking about. You are covering fundamental programming concepts & explaining them very well!!

[justapasserby]

Dude you just saved me a week's worth of back and forth

[raimundojs]

Brilliant! Thank you so much for sharing!

[SpokesAndWings]

Great video! Would have loved to find this a couple of weeks ago, but really glad to have the validation of the method! Great stuff in this channel!🎉

[ftmagicart]

Incredible demonstration Chandeep. Thank you very much.

[haihathanh]

Your video is very helpful and understandable, you're a great tutor!

[mightydrew]

There are a lot of junk/useless tutorials on YouTube at the moment... with terrible use-cases and examples. I'm a new subscriber because you are providing INCREDIBLE content and actually useful examples of how to get the most out of PowerQuery/M - fantastic, well done, well presented!

[mdsaleem]

you are real champ. Much appreciate your way of explanation.

[umesh]

Such a great way to sharing concept...yet not untill you do it by self does we realise how complicated it can be...learned another trick today...

[ourlittlesmarties]

This is so cool, Chandeep. You are the best teacher as always, thank you.

[whizzohk]

Fantastic topic clearly explained! Just the type of thing I've been trying to do lately, not having any hard-coded column names anywhere in my code.

[Harish.Prasad.Semwal]

🙂Thnak you Chandeep Paaji for teaching us interesting topic

[megabuilds]

Fantastic and Highly helpful. Thank you.

[Maartenmarsje]

As always, I really like your videos. Thanks! In real life, I still prefer to use a DAX solution for solving this specific issue. The way I use List.Acumulate is to search a text column for a specific range of projectcodes. Problem stays that Text.Contains in combination with List.Acumulate is still a terrible slow solution. If you ever have a solution for searching a specific list of codes in a text column full of other text around the codes, let me know 😊.

[baskis]

Thank you very much for sharing ... this is super useful¡¡¡¡¡

[terrylee]

Amazing knowledge pal. Thanks for sharing

[vinhwizard]

Useful but difficult. I must see many times to understand. Thank you

[MichaelBrown-lwkz]

Wow. Power Query is amazing for data prep. How did you know about that Record.Field function? I am now comfortable with the fact that I will never know everything about Power Query. I'll always be learning something new in it. Unbelievable lesson.