Power Query - Dynamically split by delimiter
Splitting a column by delimiter by using the UI is easy but it comes with one drawback it hardcodes the column names so if your dataset includes new delimiters then it wont add the new columns. in this video i show you how to dynamically split a column by a delimiter no matter how many delimiters in the column. #data #excel #powerbi #mquery #dataanalysis #datacleaning #EDA
File Link
https://github.com/jbotes/powerbiTuto...