Split columns based on delimter

[ak77]

Hi all,

Please help me in splitting the below column dynamically to new columns based on delimter (-).  i have attached the PBIX in the below link

https://drive.google.com/file/d/15eSB8yXeyh6ANRphml6OCGNhD2yb_Ud9/view?usp=sharing

[Bipin-Lala · Accepted solution]

Hi @ak77,

Dynamic column splitting in Power Query Editor, adapting to varying delimiters, can be achieved with clever M code manipulation.

While I'd love to explain the process in detail here, there's an excellent video available that walks you through the steps of dynamically splitting a column. I recommend watching the video and following the instructions provided, as it will guide you effectively in meeting your specific requirements.

https://www.youtube.com/watch?v=sngwN6bSV6M&ab_channel=BASensei

I also implemented the steps on the pbix you shared, to refresh my knowledge. I have attached the transformed pbix file and the Excel dataset used as the source

https://drive.google.com/drive/folders/1Op96VC20yQyZcTuNqHhDGrwXjc39K2BN?usp=sharing

Do let me know if you face any issues!