Power Query - Understanding each and underscore (_)

To really get down to solving complex problems in Power Query you'll need to understand how to use each and underscore. In this video i provide a bit more context on these concepts in terms of Records, Lists and Tables.
#data #dataanalytics #powerquery #mquery #excel #powerbi
File Link
github.com/jbo...

[@oz7075]

Awesome. Very well explained. Congratulations.

[@FsoOmar]

I guess I need to watch this a couple of times to grasp it firmly, but thank you, indeed, for trying to explain it. I guess this concept is the hardest of the M Language to comprehend.

[@howtolearnexcel]

Awesome tutorial and explanation! This underscore trick is so cool to make your M-code cleaner.

[@haihathanh5061]

Your videos are very cool, I rewind them many times to learn such cool tricks

[@michaelhoney1973]

Phenomenal tutorial, you are truely an epic communicator thanks so much

[@basensei8699]

glorious! thank you!

[@Hello-bn2yc]

Thank you my friend... Praise God I found your channel...this is really God sent

[@basensei8699]

You are so welcome

[@michaelmartin604]

Good video to understand this concept, cheers mate.

[@thebhaskarjoshi]

Loved it!

[@thangvan-h9p]

Thank you so much for your sharing Bro

[@sduffy4317]

Very helpful and informative, but difficult to follow with the double screen because I usually watch these on my phone. Appreciate your expertise, thank you.

[@basensei8699]

Noted!

[@MatusiSK]

Do you have a course where you teach power query ?? Because thats mi christmas wish.

[@basensei8699]

alas i dont! but maybe i should start thinking about it!

[@masgitz]

Thought i understood this. Trying to do a conditionional Table Transform columns based on value from another column, but failing field access. Any ideas

[@hesar1975]

so underscore is just like 'this' pointer to a current object used , ez but yet nice feature

[@mehmetatas5459]

hello
(InnerTable)=> (innerTable[Amount] >[Amount]
If we use each instead, what kind of function should we refer to?
= Table.AddColumn(Source,"TableCol", each
Table.SelectRows(Source, (InnerTable)=> InnerTable[Amount] > [Amount]))
each ????
I would be happy if you help

[@krcarlosm]

At beggining I was not understanding, at the middle I was lost on the explanation but at the end it seems that I was like the beggining of the video.
🙅🙅🙅

[@garylhaas2005]

i am closer to understanding Torch and Battery

[@basensei8699]

hahaha now that's a great comment

[@patrickyoung2106]

That data set was boring as hell!