Power Query - Understanding each and underscore (_)

Подписаться 3,1 тыс.

Просмотров 4,5 тыс.

50% 1

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...

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

24 апр 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

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

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

Good video to understand this concept, cheers mate.

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

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.

@Hello-bn2yc 5 месяцев назад

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

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

You are so welcome

@user-mc5rd1bp6h 4 месяца назад

Thank you so much for your sharing Bro

@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