each & underscore_ in Power Query Explained

Finally, the most requested video is here. I'll discuss the nuances of 'each' & '_' keywords in Power Query.

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

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

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

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

===== CHAPTERS =====
0:00 Intro
0:16 Understanding 'each' & Underscore_ in a Context of a Table
2:45 Understanding 'each' & Underscore_ in a Context of a List
4:27 Alternate to 'each' & Underscore_ in a Table
7:05 Alternate to 'each' & Underscore_ in a List
8:48 My Courses

===== 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
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

[amitk]

The best part of your teaching is you deep dive and great explanation and make the things easier to understand

[navisalomi]

Thanks so much. It's good to know both the each syntax sugar and the declaring a variable like (r)=>. There are cases where you're nesting functions. Once you use each _ once, if you use it again, it overwrites the first one. So, be careful. If you must use each again, declare the variable.
Example, Table.AddColumn(Source, "NewCol", each {_[Amount]} & List.Transform({2, 3, 4}, (x)=> x * _)).
You can't use the each _ in the List.Transform function. You will overwrite the first _ and cause the functions to crash.

[EmpyrialArchangel]

THANK YOU! I spent HOURS reading documentation, but all I needed was 10 minutes on YouTube. You're my hero!

[MichaelBrown-lwkz]

This is by far the best explanation I have seen regarding "each" and "_". I finally understand this. Thank you so much

[iantotheh]

Such an eloquent explanation of something I've been wondering for a while!

[Hello-bnyc]

Finally I was able to get it... Thank you so much Chandeep.

[seanys]

I wish I had seen this video when I first started trying to use Power Query.

[rpopecpa]

Thank you for this video!! A simple bit of valuable information to add to my knowledge base.

[mohamedfouad]

Love you man, I learned a lot from you and still learning

[josecarlosconejo]

You are really good at explaining things… 👍

[wayneedmondson]

Awesome explanation Chandeep! I think of each as shorthand for the function (myVar)=> and underscore as the variable myVar, as in (using your example): (myVar)=> myVar[Amount] to extract the amount from the record. I believe it is confusing to people because they experience each and _ before learning to formally declare functions. If they learned the formal way first and then learned the shorthand of each and _ it might be easier. Thanks for a great explanation.. alway good learning at Goodly! Thumbs up!!

[mohitoshbiswas]

Great explanation of each and _ keywords and their applications. Thanks Chandeep 👍

[williamarthur]

Thank you, its' about time soneone tackled this topic, I rememeber when I first started looking at M being very cofused by the Fuction (_, , that I would see. I still find there use confusing / interesting in that sometimes using a named function eg (A)=> A[whatever], will work whereas each [whatever], might not.
Thank you for all your work in putting these videos together.

[roywilson]

Thanks for the interesting video. I wish someone had explained this so clearly when I first tried to work out what the each and _ were doing and how to use them.

[QuantumIdeas]

Fantastic video, Chandeep! Each, _, () and => have been so mysterious to me before viewing this video. This is a huge for me.

[isidreb]

A great explanation, using examples that are easy to understand. Thanks for sharing!!

[OdelLeal]

Great job and very helpful your information. Súper.

[arunkumarkesavan]

Now I cant say to anyone that I am good in Power BI after watching your vidoes!!! you're the person to say it...

[komanguy]

Great! Very well explained, the meaning of the underscore and how to define a function. Thank you very much.

[ajieapen]

ah... I've been waiting for this since ages... No words to thank you, Chandeep... :)