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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
bhaskarpbi999
Helper V
Helper V

Split Weekday name and time hours in to different columns

Hi All,

 

I need your assitance to split the below data to different columns like Weekday in one column and Hours in one column.

 

bhaskarpbi999_0-1709296523757.png

Expected format either of the 2 below.

 

bhaskarpbi999_2-1709296833130.png

 

 

bhaskarpbi999_1-1709296633865.png

 

Thanks for your assistance..

 

 

 

1 ACCEPTED SOLUTION
tharunkumarRTK
Super User
Super User

@bhaskarpbi999 
You can split your data first, Text.Split("Text", "#(lf)") and then expand the list into new rows and then split the column with ":" delimiter. Attached a sample for your reference. 

https://drive.google.com/file/d/1UzkpA9aohjDfwx8Sjnytox8bJJPdd5t2/view?usp=share_link 


If the post helps please give a thumbs up


If it solves your issue, please accept it as the solution to help the other members find it more quickly.


Tharun



View solution in original post

2 REPLIES 2
tharunkumarRTK
Super User
Super User

@bhaskarpbi999 
You can split your data first, Text.Split("Text", "#(lf)") and then expand the list into new rows and then split the column with ":" delimiter. Attached a sample for your reference. 

https://drive.google.com/file/d/1UzkpA9aohjDfwx8Sjnytox8bJJPdd5t2/view?usp=share_link 


If the post helps please give a thumbs up


If it solves your issue, please accept it as the solution to help the other members find it more quickly.


Tharun



Thanks a lot for your assistance Tharun ! 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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

Top Solution Authors