Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
misiek5510
Helper III
Helper III

Split Column by Delimiter ONLY if more then one exists

Hi,

 

I wanted to split the column if dash "-" exist more than once for each row and split it without spliting the first dash. Hopefully the below will make more sense:

 

Example column to be split:

 

Sample

Sample - Sample1 

Sample - Sample1 - Sample2 - Sample3 

Sample - Sample1

Sample - Sample1

Sample - Sample1 - Sample2

 

 

Column that needs to be created:

 

Sample

Sample - Sample1

Sample - Sample1

Sample - Sample1

Sample - Sample1

Sample - Sample1

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@misiek5510 , First Use Split By Delimiter, and split on only 1st occurrence (Into two columns),

 

Then again split By Delimiter the second into rows

 

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
Thennarasu_R
Responsive Resident
Responsive Resident

Hi !
@misiek5510 

You Created Calculated Column Using Len and Left Functions
Here Attached the Ex Pic.I hope it Will help to You.

Thennarasu_R_0-1673270647843.png

Thanks,
Thennarasu

amitchandak
Super User
Super User

@misiek5510 , First Use Split By Delimiter, and split on only 1st occurrence (Into two columns),

 

Then again split By Delimiter the second into rows

 

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.