Power Query - Understanding each and underscore (_)
Рет қаралды 4,642
Жыл бұрын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/jbotes/powerbiTuto...
@michaelmartin604 Ай бұрын
Good video to understand this concept, cheers mate.
@haihathanh5061 Ай бұрын
Your videos are very cool, I rewind them many times to learn such cool tricks
@SndfOmar 3 ай бұрын
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.
@user-mc5rd1bp6h 4 ай бұрын
Thank you so much for your sharing Bro
@Hello-bn2yc 5 ай бұрын
Thank you my friend... Praise God I found your channel...this is really God sent
@basensei8699 5 ай бұрын
You are so welcome
@thebhaskarjoshi 8 ай бұрын
Loved it!
@masgitz 2 ай бұрын
Thought i understood this. Trying to do a conditionional Table Transform columns based on value from another column, but failing field access. Any ideas
@mehmetatas5459 8 ай бұрын
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
@garylhaas2005 7 ай бұрын
i am closer to understanding Torch and Battery
@basensei8699 7 ай бұрын
hahaha now that's a great comment
@patrickyoung2106 Жыл бұрын
That data set was boring as hell!
Полярная звезда - Kuzey Yıldızı
Рет қаралды 7 МЛН
Gufee.medalin
Рет қаралды 9 МЛН
Devon and Cornwall User Group | Sue Bayes
Рет қаралды 3,5 М.
Excel Off The Grid
Рет қаралды 20 М.
Miss Microsoft
Рет қаралды 67 М.