Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
@BrainyBrunetteBarbie2 жыл бұрын
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.
@GoodlyChandeep2 жыл бұрын
*I am pleased that you took a look* 😉
@karimallahwala70222 жыл бұрын
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
@GoodlyChandeep2 жыл бұрын
Wonderful!
@iancoify2 жыл бұрын
holy moly, I am blessed to have found you. Severely underrated channel.
@GoodlyChandeep2 жыл бұрын
Thanks man! Glad to find you also 💚
@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!
@RichardJones736 ай бұрын
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.
@3Starsgamer342 жыл бұрын
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
@GoodlyChandeep2 жыл бұрын
Yes correct I missed that in the video😬
@viviennesmithdorf32449 ай бұрын
You are an EXCELLENT teacher, Chandeep! 😊 Thank you for making this video and making it freely available.
@stevegarside502610 ай бұрын
Genesis! The method used to create multiple columns within a table is brilliant! Thanks for taking the time to share your knowledge 👏
@torkunc11 ай бұрын
dear chandeep, your way of explaining the issues is so clear, makes me think that pq is no more a nightmare. thank you…
@HachiAdachi2 жыл бұрын
🤯 I feel so powerful now with List.Accumulate in my toolbox! Thank you, Chandeep! 👏
@GoodlyChandeep2 жыл бұрын
Awesome! 😁
@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 :)
@jist69534 ай бұрын
This is so advanced, it is beyond most of us. Watching over 5 different sessions, I think I can finally follow through the matrix. Wow
@GoodlyChandeep4 ай бұрын
😁🙏
@bugsdenis5479 ай бұрын
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
@kennethpaige70362 жыл бұрын
Hi Chandeep, after weeks of trying I finally understand List.Accumulate! Thank you so much. The clarity of your List.Accumulate explanations is amazing.
@GoodlyChandeep2 жыл бұрын
Glad it was helpful 💚
@Sumanth16012 жыл бұрын
Have seen many videos on list.accumulate. But none as clearly defined by you. Brilliant 👍🙂
@GoodlyChandeep2 жыл бұрын
Thanks Sumanth! Glad you liked it :)
@sandipsoni404711 күн бұрын
Chandeep I really thanks for making such indepth video it clear list. Accumulate function concept
@efficiency365 Жыл бұрын
Thanks! Great stuff. Demystifying Power Query. Keep up the amazing work.
@GoodlyChandeep Жыл бұрын
Woah.. Thanks Man! 🙏
@ShrikantPatil-x5h5 ай бұрын
Chandeep, You are true rockstar. I feel blessed that I found your channel on youtube.. Keep rocking... 😊
@jaybuddhadev35438 ай бұрын
this concept was really tough but the way you explained made it very very easy. Thanks a lot
@abbadq3 ай бұрын
Brilliant Chandeep, explained this complex technique with ease and such a simple way. Awesome video.
@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!
@godwinsiabukandu2196 Жыл бұрын
This is genius. Couldn't find anything like this in any textbook.
@ricardobunge59572 жыл бұрын
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!
@GoodlyChandeep2 жыл бұрын
Glad you liked it!
@bodhanandannhattuvetty31792 жыл бұрын
You are a very good teacher. Thank you very much for explaining complex things in a simple way.
@GoodlyChandeep2 жыл бұрын
Glad you think so!
@BillSzysz12 жыл бұрын
Thanks for video, Chandeep 🙂 I am impressed by the clarity of the explanation of difficult parts of the issue 👍
@GoodlyChandeep2 жыл бұрын
Hi Bill. I am honoured to have you here. thank you!
@adrianhoraciosantanavaldes19089 ай бұрын
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
@sbatsia2 жыл бұрын
Clear and thorough teaching. You're an excellent tutor. Thank YOU.
@GoodlyChandeep2 жыл бұрын
You're very welcome!
@GosCee2 жыл бұрын
Brilliant! Nicely done, Chandeep. Very well explained. I'm sure I'll find use for this immediately. Thank you very much.
@GoodlyChandeep2 жыл бұрын
Sure! Glad you like it
@udusegbe2 жыл бұрын
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! 😀
@chandeepchhabra2 жыл бұрын
Glad you enjoyed it Bare!
@umeshlangade92312 жыл бұрын
Thank you so much Goodly for this masterpiece 😊
@henryseah1162 Жыл бұрын
I learnt a lot from you. Thank you Chandeep!
@amitk12082 жыл бұрын
Your explanation is wonderful one can easily understand even Complex formula
@GoodlyChandeep2 жыл бұрын
Thanks 💚
@jimfitch2 жыл бұрын
I’ve watched several tutorials on List.Accumulate. This is the best by far. Thank you, Chandeep.
@GoodlyChandeep2 жыл бұрын
Glad it helped 💚
@Oprimaita2 жыл бұрын
Really a great tutorial ! Thank you so much ! I’ m sure I will use in my job.
@GoodlyChandeep2 жыл бұрын
Sure man!
@pawewrona97492 жыл бұрын
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
@KamranMumtazAhmed8 ай бұрын
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.
@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!
@ryanschumacher51492 жыл бұрын
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! 💓
@GoodlyChandeep2 жыл бұрын
Glad it was helpful !
@sanjeevsoni67932 жыл бұрын
Great Goodly!!, Made simple to under List.Accumulate,
@GoodlyChandeep2 жыл бұрын
Thanks!
@excel-in-g2 жыл бұрын
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.
@GoodlyChandeep2 жыл бұрын
Cool!
@enocharthur43222 жыл бұрын
You're a really really great tutor!!!
@GoodlyChandeep2 жыл бұрын
Thank you!
@MichaelBrown-lw9kz6 ай бұрын
I watched this video again. Chandeep is that dude. My goodness he has a talent for providing instruction.
@kirstinlarson3880 Жыл бұрын
You are a great trainer!! Thank you for this easy to follow tutorial!❤❤❤❤❤
@sumardjo7 ай бұрын
Thanks your Tutorial Power Query Special thanks for sample file I Can step by step with sample file thanks very much
@learningmadesimple3472 жыл бұрын
Love it love it love it... great job..
@GoodlyChandeep2 жыл бұрын
Thanks 💚
@mnowako2 жыл бұрын
What an amazing video. Hats off! Thanks a lot!
@GoodlyChandeep2 жыл бұрын
Glad you like it!
@MichaelBrown-lw9kz Жыл бұрын
You sir are a phenomenal instructor.
@GoodlyChandeep Жыл бұрын
Thanks Michael!
@sachin.tandon2 жыл бұрын
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!
@sue_bayes2 жыл бұрын
Totally enjoyable, thank you Chandeep. Also using the Closing Balance analogy really helped with the explanation.😊
@GoodlyChandeep2 жыл бұрын
Thanks Susan. Glad you enjoyed it :)
@timolff92392 жыл бұрын
the quality of these videos are mind blowing.
@GoodlyChandeep2 жыл бұрын
Glad you think so!
@mrtfia Жыл бұрын
This is insane! 🙌🏻🙌🏻 You are a god ! Thank you so much.
@kimgraf4085 Жыл бұрын
Amazing. Brilliant stuff! Will take me a few watches to learn for sure!
@GoodlyChandeep Жыл бұрын
Thanks Kim!
@alirezahossini4632 жыл бұрын
Absolutely is brilliant 👏. Best way to show the matrix .
@GoodlyChandeep2 жыл бұрын
Thank You !
@danishnawaz75042 жыл бұрын
You are Amazing
@einoconsult55632 жыл бұрын
Thanks Chandeep :) I just added a List.Sort on AllTrainings list to order the courses alphabetically, easier to read :)
@alphamaniac94112 жыл бұрын
Awesome examples. You are now a go to person for me to help solve problems!
@GoodlyChandeep2 жыл бұрын
Glad to help!
@poulpon1164 Жыл бұрын
Thank you! Brilliant and useful as usual!
@martyc56742 жыл бұрын
I’m going to have to watch this a few times!! Nice work Chandeep!!
@GoodlyChandeep2 жыл бұрын
Thank You Martin!
@williamarthur48012 жыл бұрын
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.
@darwisyb5 ай бұрын
Thanks.i thought i need watch your video more :)
@navisalomi2 жыл бұрын
Great teacher...takes time to break things down.
@GoodlyChandeep2 жыл бұрын
💚
@QasimAli-gy3nb2 жыл бұрын
You really really really knock it out chandeep.
@GoodlyChandeep2 жыл бұрын
Thanks! 💚
@malchicken2 жыл бұрын
So helpful ^^, thank you 🙏.
@mshparber2 жыл бұрын
AWESOME! Thanks! Closing Balance is a great sample!
@GoodlyChandeep2 жыл бұрын
Glad you like it!
@dirkstaszak48382 жыл бұрын
Oh man nice one again. 👍
@GoodlyChandeep2 жыл бұрын
Thanks Man!
@weav806017 күн бұрын
I used this to find the header row in messy files, looking for the row record that has the largest number of matches with a list of likely/expected column names... Comes up often in common mission-critical files 'compromised' header formats (starting location, multi-line, etc,)
@KamranMumtazAhmed8 ай бұрын
Thank you for the great explanations.
@cheikhhakim58642 жыл бұрын
thank you Chandeep i m grateful
@GoodlyChandeep2 жыл бұрын
You're most welcome
@emilmubarakshin49 Жыл бұрын
Amazing function and fantastic explanation
@GoodlyChandeep Жыл бұрын
Glad you liked it!
@pavelfilippov-nt2ni6 ай бұрын
Thank you for lesson! Marvelous!
@MrKamranhaider02 жыл бұрын
great sir learned a lot .I working on weighted average cost .I think this will solve my problem.
@chandeepchhabra2 жыл бұрын
Awesome thanks
@ViktorSamosiuk-wu5fq7 ай бұрын
so great tutorial!! Thank you so much!
@krzysiekbanach37372 жыл бұрын
Just WOW!!!! :D Thanks a lot!!!
@juancarlosleytonfernandez9146 Жыл бұрын
Aweshome!!! Amazing!!
@RohanGupta_LP2 жыл бұрын
Wowww. Thanks for the explanation.
@pratapindian86064 ай бұрын
Your videos are awesome. I have one problem sir. Please explain the reversal of the last example. For example if we have an OutputTable as our source and I want to concatenate column headers based on true or false values of each record. Complete reverse of this example. Thank you for your response.
@odallamico7 ай бұрын
Absolutely amazing !!!!!
@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!
@rrrraaaacccc80 Жыл бұрын
Excellent 💯👍👏
@GoodlyChandeep Жыл бұрын
Thank you !
@thebhaskarjoshi2 жыл бұрын
Thanks for video, Chandeep 🙂amazing content as always
@GoodlyChandeep2 жыл бұрын
Glad you like this 💚
@mohammedmanna34882 жыл бұрын
Thanks a Lot sir I will try to used in Financial Area I need it
@ravamo0053 Жыл бұрын
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
@kennethstephani6922 жыл бұрын
Another Great Video!!
@GoodlyChandeep2 жыл бұрын
Glad you like it!
@TheTommySp22 күн бұрын
"I'm gonna say :hey!..you are the best
@sebastienschoonjans97272 жыл бұрын
You explain things so well
@GoodlyChandeep2 жыл бұрын
Thank You !
@sebastienschoonjans97272 жыл бұрын
@@GoodlyChandeep would it be possible for me to ask you a question concerning a case using list.accumulate?
@kebincui2 жыл бұрын
Very well explained
@GoodlyChandeep2 жыл бұрын
Glad you liked it!
@MacarServicios2 жыл бұрын
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!
@chandeepchhabra2 жыл бұрын
Gracias!
@DavidGzirishvili2 жыл бұрын
Fantastic! Thanks a lot!
@shamafirdos80772 жыл бұрын
Amazingggggg... thanks for sharing
@GoodlyChandeep2 жыл бұрын
pleasure 😊
@nicopicco Жыл бұрын
this is like the reduce() function on JavaScript. Interesting how this also uses arrow functions like the latest JS
@powerbinareal2 жыл бұрын
Sempre TOP! #powerbinareal
@GoodlyChandeep2 жыл бұрын
Thanks!
@anfiiiii2 жыл бұрын
Brilliant, thanks bro
@GoodlyChandeep2 жыл бұрын
💚
@TheCraigie0072 жыл бұрын
Thanks , Loved It !
@GoodlyChandeep2 жыл бұрын
💚
@pavelandreev60232 жыл бұрын
Great 👍!!!
@GoodlyChandeep2 жыл бұрын
Thanks!
@gdecome3 ай бұрын
Impressive!
@aslamwaris2 жыл бұрын
Superb chandeep
@GoodlyChandeep2 жыл бұрын
Thanks!
@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
@bartomiejonak50132 жыл бұрын
Hey - Excel Is Fun children keep the father's level and extract Power (Query) of current XL tools. Keep it goin PQ.
@rond92222 жыл бұрын
Great video! One question, how would you handle this is 2 people took the same training class - let's say someone else took the Excel class too?
@chandeepchhabra2 жыл бұрын
I'd just use list.distinct while creating a list. Rest remains the same
@MichaelBrown-lw9kz6 ай бұрын
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?