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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rachelbi
Helper I
Helper I

How to extract the date between "and" rather than delimiter

Hi there, I would like to add public holiday in the calendar visual, yet I don't know how to extract the date properly between two dates which are joined by "and" instead of any delimiter, grateful to have some tips. Thank you.

 

rachelbi_0-1713755924669.png

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@rachelbi 

you can try split by "and" and to rows

11.PNG12.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@rachelbi 

you can try split by "and" and to rows

11.PNG12.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thanks @ryan_mayu  I tried your suggestion yet the date format e.g. "Sunday 1 January" cannot be formatted to 1/1/2023 (below capscreen). Wonder what should I do? Appreciated.

source: Public holidays | Recreation, sport and arts | Queensland Government (www.qld.gov.au) 

rachelbi_0-1713763612885.png

 

@rachelbi 

then you extracted text after space

11.PNG

 

then create a custom column

 

12.PNG

 

13.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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