Power Query - Dynamically Split into Columns
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
https://github.com/jbotes/powerbiTuto...
My Site
https://basensei.com/
Links to Functions used
https://learn.microsoft.com/en-us/pow...
https://learn.microsoft.com/en-us/pow...
https://learn.microsoft.com/en-us/pow...
https://learn.microsoft.com/en-us/pow...
https://learn.microsoft.com/en-us/pow...
https://learn.microsoft.com/en-us/pow...