topic Extracting Certain Characters from Text Column in DAX Commands and Tips

Extracting Certain Characters from Text Column

Ankurdatascienc — Thu, 10 Apr 2025 07:47:54 GMT

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.

Re: Extracting Certain Characters from Text Column

bhanu_gautam — Thu, 10 Apr 2025 08:55:42 GMT

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()
)

Re: Extracting Certain Characters from Text Column

v-pnaroju-msft — Sun, 13 Apr 2025 17:14:51 GMT

Thank you, bhanu_gautam, for 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.

Re: Extracting Certain Characters from Text Column

gmsamborn — Sun, 13 Apr 2025 22:35:07 GMT

Hi @Ankurdatascienc

Is Power Query an option?

If so, you could:

Duplicate the [Job Name] column.
Split by delimiter
- “.” As delimiter
- Starting from right
- 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.

Re: Extracting Certain Characters from Text Column

v-pnaroju-msft — Wed, 16 Apr 2025 20:14:42 GMT

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.

Re: Extracting Certain Characters from Text Column

v-pnaroju-msft — Sun, 20 Apr 2025 17:59:53 GMT

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.