List.Accumulate in Power Query with Practical Examples

Подписаться 89 тыс.

Просмотров 63 тыс.

50% 1

Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
All Answers - goodly.co.in/create-dynamic-c...
Download file - goodly.co.in/wp-content/uploa...
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== CHAPTERS =====
0:00 Intro
0:40 Understanding the Syntax of List.Accumulate
4:42 Simple Example
9:39 Complicated Example
13:11 Solution to Power Query Challange
25:58 Shoutout!
===== 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!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ
Official After The Fall RU-vid Channel Below
ru-vid.com/show-UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses

Наука

Опубликовано:

29 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 219

@GoodlyChandeep 7 месяцев назад

Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/

@MichaelBrown-lw9kz 23 дня назад

I watched this video again. Chandeep is that dude. My goodness he has a talent for providing instruction.

@RichardJones73 23 дня назад

Sometimes i hate you cos you make power query look so easy and sometimes i love you because you make power query so much easier. Great job sir.

@BrainyBrunetteBarbie Год назад

As an accountant I love that you used “closing balance” in your example. ALSO, it would not be a Goodly video without “Please take a look”! That phrase always makes me smile.

@GoodlyChandeep Год назад

*I am pleased that you took a look* 😉

@karimallahwala7022 Год назад

The Example „closing Balance“ was fantastic. It gave me so much opportunities for use this „List.accumulate“ Thank you so much. You lift my Powerquery-using-possibilties to another Dimension. Thank you so much. Really excellent and out-Standings Content you offer

@GoodlyChandeep Год назад

Wonderful!

@3Starsgamer34 Год назад

Wonderful. You opened the way of looping in PQ. I think the list need to be wrapped in List. Distinct to get unique values for trainings

@GoodlyChandeep Год назад

Yes correct I missed that in the video😬

@viviennesmithdorf3244 3 месяца назад

You are an EXCELLENT teacher, Chandeep! 😊 Thank you for making this video and making it freely available.

@stevegarside5026 4 месяца назад

Genesis! The method used to create multiple columns within a table is brilliant! Thanks for taking the time to share your knowledge 👏

@kirstinlarson3880 Год назад

You are a great trainer!! Thank you for this easy to follow tutorial!❤❤❤❤❤

@torkunc 5 месяцев назад

dear chandeep, your way of explaining the issues is so clear, makes me think that pq is no more a nightmare. thank you…

@iancoify Год назад

holy moly, I am blessed to have found you. Severely underrated channel.

@GoodlyChandeep Год назад

Thanks man! Glad to find you also 💚

@ryanschumacher5149 Год назад

Thank you so much for sharing! Your approach through this powerful and complex function was extremely helpful and educational. I really appreciate that you started with the basics and then proceeded into a "real world" example. I learned a lot! 💓

@GoodlyChandeep Год назад

Glad it was helpful !

@raimundojs9547 Год назад

Thank you! You've been the first one to teach this particular function with clear explanations. You have no idea how helpful your videos are.

@GoodlyChandeep Год назад

You have no idea how much your comment means to me :)

@sachin.tandon Год назад

Fantastic example, and very advanced! If I were to provide "critical feedback" to get you from a Gold Star to a Platinum Star, on par with Alberto Ferrari et all, it would be to spell out some of the "sometimes' hastily given, "end of sentence" explanations. I think you did it once or twice. Otherwise, I love your channel, and I love the ideas that you come up with. Great work!

@mrtfia 7 месяцев назад

This is insane! 🙌🏻🙌🏻 You are a god ! Thank you so much.

@adrianhoraciosantanavaldes1908 3 месяца назад

this is awesome, i love it, used it already a couple of times, but where i think can be used but haven't been able to is if i want to split into separate columns multiple dynamically, i have many data sets where the desired output would be a "main column" to their "related value", lets say for simplicity you have 4 columns, the "main column" where you have distinct values {lenght, depth, width} but they are not unique values; the next columns would be "mm.1" for the first value in mm, "mm.2" for the second value in mm, "mm.3" for the third value in mm, etc and the same thing for "in" and "ft", the table originally starts as "main column", "mm", "in", "ft". what i do normally is i group by the first column, the "main column" and then manually split the other columns into different columns, getting the desired output. now in my data its normally around the 15 columns ("mm", "in", "ft", "gauss", etc) and to do 15 times that is quite an issue. what this video gave me the idea was to have as seed the grouped table, and from there start to split. up till the present i haven't been able to make it work using the ideas of this video, anything i might be missing? thank you if you read this far and are willing to help btw

@ricardobunge5957 Год назад

Hi Chandeep - brilliant as usual! Very much like the graduated approach - makes it very easy to understand the complex examples. I can see many potential applications in our current portfolio... Thanks again!

@GoodlyChandeep Год назад

Glad you liked it!

@jaybuddhadev3543 3 месяца назад

this concept was really tough but the way you explained made it very very easy. Thanks a lot

@umeshlangade9231 Год назад

Thank you so much Goodly for this masterpiece 😊

@udusegbe Год назад

Not just "absolutely gorgeous" but as well absolutely awesome! It took me quite a well to get a grip on this powerful PQ function (and still not mastered even) but your logical step by step approach makes it so easy. Thanks, Chandeep. I will definitely over my application but this time with an enlightened insight from goodly! 😀

@chandeepchhabra Год назад

Glad you enjoyed it Bare!

@BillSzysz1 Год назад

Thanks for video, Chandeep 🙂 I am impressed by the clarity of the explanation of difficult parts of the issue 👍

@GoodlyChandeep Год назад

Hi Bill. I am honoured to have you here. thank you!

@poulpon1164 Год назад

Thank you! Brilliant and useful as usual!

@sumardjo Месяц назад

Thanks your Tutorial Power Query Special thanks for sample file I Can step by step with sample file thanks very much

@pawewrona9749 Год назад

In this last exercise, when you create new columns, you could simply do TextContains(Training, TrainingName), and save yourself splitting, and then couple of iterations

@KamranMumtazAhmed 2 месяца назад

Thank you for the comment. I tried your idea and the code became too small compared to what Chandeep taught in the video. let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], Result = List.Accumulate(TL, Source, (s,c) => Table.AddColumn(s,c, each Text.Contains([Training], c))) in Result Moreover, I took another precaution on the TainingList side and used the List.Distinct to remove duplication in the header names.

@joaorataoo Год назад

Magnificent!!! I just don't know what is more magnificent, if the function, or your way of explaining it! The way you explain is a gift.

@GoodlyChandeep Год назад

Really Glad ! Thanks João!

@zahoorsarbandi2982 Год назад

Absolutely amazing! Believe me this is the single video available on internet which has explained the List.Accumulate so easily and perfectly that only this lecture is sufficient to watch for complete understanding for this difficult function. Well Done!

@GoodlyChandeep Год назад

Wow, thank you!

@excel-in-g Год назад

Love this. Great example. It's one of those functions that I find hard to grasp what I can do with it. I now understand it's a lot more then I imagined.

@GoodlyChandeep Год назад

Cool!

@pavelfilippov-nt2ni 8 дней назад

Thank you for lesson! Marvelous!

@Oprimaita Год назад

Really a great tutorial ! Thank you so much ! I’ m sure I will use in my job.

@GoodlyChandeep Год назад

Sure man!

@henryseah1162 10 месяцев назад

I learnt a lot from you. Thank you Chandeep!

@williamarthur4801 Год назад

Looking forward to watching this, I've used it to create running totals but never really understood quite how it works.. I may have questions.. Enjoyed Promoting two rows to Headers, TableInsertRows could do with it's own show. Richard.

@ViktorSamosiuk-wu5fq Месяц назад

so great tutorial!! Thank you so much!

@kennethpaige7036 Год назад

Hi Chandeep, after weeks of trying I finally understand List.Accumulate! Thank you so much. The clarity of your List.Accumulate explanations is amazing.

@GoodlyChandeep Год назад

Glad it was helpful 💚

@godwinsiabukandu2196 11 месяцев назад

This is genius. Couldn't find anything like this in any textbook.

@bodhanandannhattuvetty3179 Год назад

You are a very good teacher. Thank you very much for explaining complex things in a simple way.

@GoodlyChandeep Год назад

Glad you think so!

@sbatsia Год назад

Clear and thorough teaching. You're an excellent tutor. Thank YOU.

@GoodlyChandeep Год назад

You're very welcome!

@HachiAdachi Год назад

🤯 I feel so powerful now with List.Accumulate in my toolbox! Thank you, Chandeep! 👏

@GoodlyChandeep Год назад

Awesome! 😁

@alphamaniac9411 Год назад

Awesome examples. You are now a go to person for me to help solve problems!

@GoodlyChandeep Год назад

Glad to help!

@bugsdenis547 3 месяца назад

Nothing else than 😄 really usefull and well explained One detail a List.Distinct will avoid errors when a training has been done by multiple persons

@efficiency365 11 месяцев назад

Thanks! Great stuff. Demystifying Power Query. Keep up the amazing work.

@GoodlyChandeep 11 месяцев назад

Woah.. Thanks Man! 🙏

@malchicken Год назад

So helpful ^^, thank you 🙏.

@kimgraf4085 Год назад

Amazing. Brilliant stuff! Will take me a few watches to learn for sure!

@GoodlyChandeep Год назад

Thanks Kim!

@GosCee Год назад

Brilliant! Nicely done, Chandeep. Very well explained. I'm sure I'll find use for this immediately. Thank you very much.

@GoodlyChandeep Год назад

Sure! Glad you like it

@KamranMumtazAhmed 2 месяца назад

Thank you for the great explanations.

@Sumanth1601 Год назад

Have seen many videos on list.accumulate. But none as clearly defined by you. Brilliant 👍🙂

@GoodlyChandeep Год назад

Thanks Sumanth! Glad you liked it :)

@odallamico Месяц назад

Absolutely amazing !!!!!

@learningmadesimple347 Год назад

Love it love it love it... great job..

@GoodlyChandeep Год назад

Thanks 💚

@enocharthur4322 Год назад

You're a really really great tutor!!!

@GoodlyChandeep Год назад

Thank you!

@krzysiekbanach3737 Год назад

Just WOW!!!! :D Thanks a lot!!!

@DavidGzirishvili Год назад

Fantastic! Thanks a lot!

@einoconsult5563 Год назад

Thanks Chandeep :) I just added a List.Sort on AllTrainings list to order the courses alphabetically, easier to read :)

@mshparber Год назад

AWESOME! Thanks! Closing Balance is a great sample!

@GoodlyChandeep Год назад

Glad you like it!

@navisalomi Год назад

Great teacher...takes time to break things down.

@GoodlyChandeep Год назад

💚

@RohanGupta_LP Год назад

Wowww. Thanks for the explanation.

@sue_bayes Год назад

Totally enjoyable, thank you Chandeep. Also using the Closing Balance analogy really helped with the explanation.😊

@GoodlyChandeep Год назад

Thanks Susan. Glad you enjoyed it :)

@mnowako Год назад

What an amazing video. Hats off! Thanks a lot!

@GoodlyChandeep Год назад

Glad you like it!

@danishnawaz7504 Год назад

You are Amazing

@mohammedmanna3488 Год назад

Thanks a Lot sir I will try to used in Financial Area I need it

@MacarServicios Год назад

WOW Chandeep, Excelente! lo haces ver tan sencillo! me gustaría ver las otras diferentes soluciones que comentabas al principio del video. Un cordial saludo!

@chandeepchhabra Год назад

Gracias!

@dirkstaszak4838 Год назад

Oh man nice one again. 👍

@GoodlyChandeep Год назад

Thanks Man!

@sanjeevsoni6793 Год назад

Great Goodly!!, Made simple to under List.Accumulate,

@GoodlyChandeep Год назад

Thanks!

@alirezahossini463 Год назад

Absolutely is brilliant 👏. Best way to show the matrix .

@GoodlyChandeep Год назад

Thank You !

@juancarlosleytonfernandez9146 Год назад

Aweshome!!! Amazing!!

@amitk1208 Год назад

Your explanation is wonderful one can easily understand even Complex formula

@GoodlyChandeep Год назад

Thanks 💚

@jimfitch Год назад

I’ve watched several tutorials on List.Accumulate. This is the best by far. Thank you, Chandeep.

@GoodlyChandeep Год назад

Glad it helped 💚

@martyc5674 Год назад

I’m going to have to watch this a few times!! Nice work Chandeep!!

@GoodlyChandeep Год назад

Thank You Martin!

@kot23 Год назад

Hey Chandeep, great video and very well-explained as well, helped to understand "(a,b) => function" in power query. Would it be possible to simply use Text.Contains() when decinding for True/False? (Did not go through all the comments, maybe I missed this question). Great job!

@user-gu8wb3ui5x Год назад

Your way of explaining this list.accumulate is simply awesome. This is very powerful function!!

@user-gu8wb3ui5x Год назад

Thanks for the efforts you had put in here.

@GoodlyChandeep Год назад

Glad you like this A!

@MrKamranhaider0 Год назад

great sir learned a lot .I working on weighted average cost .I think this will solve my problem.

@chandeepchhabra Год назад

Awesome thanks

@MichaelBrown-lw9kz Год назад

You sir are a phenomenal instructor.

@GoodlyChandeep Год назад

Thanks Michael!

@QasimAli-gy3nb Год назад

You really really really knock it out chandeep.

@GoodlyChandeep Год назад

Thanks! 💚

@nicopicco Год назад

this is like the reduce() function on JavaScript. Interesting how this also uses arrow functions like the latest JS

@timolff9239 Год назад

the quality of these videos are mind blowing.

@GoodlyChandeep Год назад

Glad you think so!

@vwij1736 9 месяцев назад

Awesome!

@ravamo0053 6 месяцев назад

Great video, it has helped me a lot, but I wonder, if I have in my dataset many of these columns that I have to map, would I have to make a table duplicating the original? it will not be heavy for powerbi

@thebhaskarjoshi Год назад

Thanks for video, Chandeep 🙂amazing content as always

@GoodlyChandeep Год назад

Glad you like this 💚

@TheCraigie007 Год назад

Thanks , Loved It !

@GoodlyChandeep Год назад

💚

@KjeldSeegert Год назад

This is incredibly well explained. Thank you very much for. Is it possible to reflect a date (for example, when the training was completed) as a value instead of True or false? 25:58 Best regards Kjeld

@kennethstephani692 Год назад

Another Great Video!!

@GoodlyChandeep Год назад

Glad you like it!

@cheikhhakim5864 Год назад

thank you Chandeep i m grateful

@GoodlyChandeep Год назад

You're most welcome

@powerbinareal Год назад

Sempre TOP! #powerbinareal

@GoodlyChandeep Год назад

Thanks!

@koenhuet5941 10 месяцев назад

Great vid! Hey is there a similar function for lists going horizontal (so for a (part of) rows)?

@Sheepy0861 5 месяцев назад

Just wow ..

@emilmubarakshin49 Год назад

Amazing function and fantastic explanation

@GoodlyChandeep Год назад

Glad you liked it!

@MichaelBrown-lw9kz 25 дней назад

I always watch this video. In your original table no two people take the same training class. For instance, Rechet takes Power Query and Excel, but no other individual takes these two trainings; so when you create a list of all the training classes from the Training field you have a list of unique training classes. However if for example CJ trained in Trading and Excel then your list would have two instances of Excel. When this happens how do you get your list to have distinct values? In other words, how do you remove duplicates from a list?

@anfiiiii Год назад

Brilliant, thanks bro

@GoodlyChandeep Год назад

💚

@rwilson101 Год назад

Beautiful!

@GoodlyChandeep Год назад

Thank you!

@shamafirdos8077 Год назад

Amazingggggg... thanks for sharing

@GoodlyChandeep Год назад

pleasure 😊

@sandipansarkar9211 6 месяцев назад

Finished watching

@Nalaka-Wanniarachchi 5 месяцев назад

Absolutely Gorgeous !!!

@rrrraaaacccc80 Год назад

Excellent 💯👍👏

@GoodlyChandeep Год назад

Thank you !

@pavelandreev6023 Год назад

Great 👍!!!

@GoodlyChandeep Год назад

Thanks!

@noahhadro8213 Год назад

great video. do you have video that shows how I could accomplish the following? I have a list of 4 values. I need to turn that into a list of every possible combination. For example: if the original list is apple, banana, grape, pear. A new list is created and for each row it would contain a unique combination of the 4 original list items separated by commas. so the first row might show banana, apple, grape, pear.................. next row in the list might show grape, apple, banana, pear............ next grape, banana, apple pear..... etc. Thanks so much for the great content.