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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
bhaskarpbi999
Helper III
Helper III

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
Solution Sage
Solution Sage

@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
Solution Sage
Solution Sage

@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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors