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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Ankurdatascienc
Regular Visitor

Extracting Certain Characters from Text Column

I have a column where data is in Format of Designation.Function.Skill.Domain and I want to extract only SKill.Domain. Please see the below photo and let me know what is the mistake I am doing.

 

Ankurdatascienc_0-1744271264862.png

 

2 ACCEPTED SOLUTIONS
bhanu_gautam
Super User
Super User

@Ankurdatascienc , Try using

DAX
Extract_Skill_Domain =
VAR FirstDot = SEARCH(".", 'Workday Report'[Job Name], 1, -1)
VAR SecondDot = SEARCH(".", 'Workday Report'[Job Name], FirstDot + 1, -1)
VAR ThirdDot = SEARCH(".", 'Workday Report'[Job Name], SecondDot + 1, -1)
RETURN
IF(
FirstDot > 0 && SecondDot > 0 && ThirdDot > 0,
MID('Workday Report'[Job Name], SecondDot + 1, LEN('Workday Report'[Job Name]) - SecondDot),
BLANK()
)




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






View solution in original post

gmsamborn
Super User
Super User

Hi @Ankurdatascienc

 

Is Power Query an option?

 

If so, you could:

  • Duplicate the [Job Name] column.
  • Split by delimiter
    • “.” As delimiter
    • Starting from right
    • gmsamborn_0-1744582745182.png
    • That should give you your [Domain] column.
  • Using the “left part” of the previous step, repeat the process.
    • That should give you your [Skill] column.
  • Delete the resulting “left part” and concatenate and/or rename the new columns accordingly.

I hope this helps.

 



Proud to be a Super User!

daxformatter.com makes life EASIER!

View solution in original post

5 REPLIES 5
v-pnaroju-msft
Community Support
Community Support

Hi Ankurdatascienc,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

v-pnaroju-msft
Community Support
Community Support

Hi Ankurdatascienc,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

gmsamborn
Super User
Super User

Hi @Ankurdatascienc

 

Is Power Query an option?

 

If so, you could:

  • Duplicate the [Job Name] column.
  • Split by delimiter
    • “.” As delimiter
    • Starting from right
    • gmsamborn_0-1744582745182.png
    • That should give you your [Domain] column.
  • Using the “left part” of the previous step, repeat the process.
    • That should give you your [Skill] column.
  • Delete the resulting “left part” and concatenate and/or rename the new columns accordingly.

I hope this helps.

 



Proud to be a Super User!

daxformatter.com makes life EASIER!
v-pnaroju-msft
Community Support
Community Support

Thank you, @bhanu_gautamfor your response.

 

Hi @Ankurdatascienc,

 

We would like to check if the solution provided by @bhanu_gautam  has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.

 

Thank you.

bhanu_gautam
Super User
Super User

@Ankurdatascienc , Try using

DAX
Extract_Skill_Domain =
VAR FirstDot = SEARCH(".", 'Workday Report'[Job Name], 1, -1)
VAR SecondDot = SEARCH(".", 'Workday Report'[Job Name], FirstDot + 1, -1)
VAR ThirdDot = SEARCH(".", 'Workday Report'[Job Name], SecondDot + 1, -1)
RETURN
IF(
FirstDot > 0 && SecondDot > 0 && ThirdDot > 0,
MID('Workday Report'[Job Name], SecondDot + 1, LEN('Workday Report'[Job Name]) - SecondDot),
BLANK()
)




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.