Power Query - Dynamically Split into Columns

Рет қаралды 5,490

Жыл бұрын

Dynamically Splitting a delimited column in a dataset into various columns for each value is quite useful to learn. in this tutorial i show you how to dodge Power Query's default hard coding and make the titles and the splits dynamic based on the portfolio's of some value investors.
#data #dataanalytics #portfolio #powerquery #powerbi #excel #mquery #m
Links
File Used in video
github.com/jbotes/powerbiTuto...
My Site
basensei.com/
Links to Functions used
learn.microsoft.com/en-us/pow...
learn.microsoft.com/en-us/pow...
learn.microsoft.com/en-us/pow...
learn.microsoft.com/en-us/pow...
learn.microsoft.com/en-us/pow...
learn.microsoft.com/en-us/pow...

Пікірлер: 13

@alexrosen8762 Жыл бұрын

Super useful tutorial and I really appreciate the added link for the file used in the video so I can follow along on a practical level 👌🙏👌

@Softwaretrain Жыл бұрын

Thank you, another way is sort descending custom column then split column and just remove last part of the function. It will create column based on first row.

@basensei8699 Жыл бұрын

incredible! i didnt know that! thanks for the tip!

@dennisr3820 5 ай бұрын

Thanks a lot. You saved my day.

@roywilson9580 Жыл бұрын

Thank you, nice video. I would personally have added a few extra steps so the query turns out a proper dataset then set it up as a function that can be invoked whenever new files are added to the portfolio directory.

@basensei8699 Жыл бұрын

yes totally agree functions are the way to go here

@FRANKWHITE1996 6 ай бұрын

Subscribed 🎉

@basensei8699 6 ай бұрын

glorious than you!

@Sh0ckTV Жыл бұрын

can you sort the stocks before the split so the same stock appears is the same column per row? i.e. null null HIJ in one row and another ABC null HIJ

@basensei8699 Жыл бұрын

yes totally!

@smartlearningoptions7609 3 ай бұрын

I need the same thing. an example of this will help.

@excel-k-sir 7 ай бұрын

Hello Dear, Thanks for the nice video. I have a column with multiple line items where I want to split the column into two columns the only criteria is that the split has to happen from the fourth instance of the Space from Right to left. I know it is possible but don't know how to do it.