Each syntax in PowerQuery explained | Extracting maximum value from a Text delimited column

Рет қаралды 4,989

Күн бұрын

In this video, we are explaining how to extract the largest number from a text field. The main focus is on the each syntax - the Power Query sugar syntax for function!
By using each keyword, we are doing iteration row by row, and invoking a function on each row of the nested table/list.
To learn more about Power Query, check out our PowerQuery fundamentals course!
exceed.hr/en/academy/powerque...
Timestamps
0:00 Intro
0:45 Splitting text values
3:02 Transform lists
5:36 Each syntax
6:25 Wrap up
#powerquery #powerbi #etltools #data #dataanalysis

Пікірлер: 16

@gFowmy 3 жыл бұрын

Thanks for your clear explanation.

@StefanoVerugi Жыл бұрын

this and Goodly's are the only videos on YT I was able to find on this subject so far and I prefer this one, thanks

@drewbbc7074 Жыл бұрын

Brilliant

@eduardomunoz2764 Ай бұрын

Awesome, thanks you. (Extraordinario gracias).

@wayneedmondson1065 2 жыл бұрын

Awesome! Thanks for demonstrating and explaining this concept. Very helpful! Thumbs up!!

@Giridharan952 3 жыл бұрын

Sir, Best wishes. Goin by step by step with basic....wow. ... gift for you from god... you will cross several milesones and success

@Rice0987 2 жыл бұрын

Thank you, guy! Good tiny blog. :)

@oliverscheurich9202 Жыл бұрын

Great. You should have 158.000 subscribers instead of 1.580.

@davidsylvestre928 Жыл бұрын

Obrigado pela explicação clara e simples.

@pamphlex 8 ай бұрын

Great sutff, Thank you.

@kennethstephani692 Жыл бұрын

Great Video!

@mirrrvelll5164 5 ай бұрын

Nice explanation of each _ =)

@spazzattack4life739 3 жыл бұрын

Can you do a video that covers multiple outputs for an if function ex: if 1=1, do x and do y? Running through a problem with list.accumulate where running two commands would be useful. Also watched your list.accumulate and it was a good starting point!