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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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