Power Query - Dynamically Split into Columns
HTML-код
- Опубликовано: 23 авг 2024
- 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/jbo...
My Site
basensei.com/
Links to Functions used
learn.microsof...
learn.microsof...
learn.microsof...
learn.microsof...
learn.microsof...
learn.microsof...
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.
incredible! i didnt know that! thanks for the tip!
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 👌🙏👌
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.
yes totally agree functions are the way to go here
Thanks a lot. You saved my day.
Subscribed 🎉
glorious than you!
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.
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
yes totally!
I need the same thing.
an example of this will help.