Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Mohamed Azarudeen]

Hi,

How would i get initial from Full Name , For example Jason John , i need to have like this JH
Please help me in to solve this problem .Thanks in Advance

Thanks and Regards,
Azar.

——————————
Mohamed Azarudeen
BI Developer
IV
chennai
9790777218
——————————

[Audrey Abbey]

You will have to use a calculated column and some string manipulation functions.
The challenge is that you may have different patterns in your data.
String manipulation depends on patterns, so if you have different patterns it can get really messy.

This will work as long as the pattern is FirstName {space} LastName.

Initials = LEFT(‘Table'[Column1], 1) & MID(‘Table'[Column1], SEARCH(” “, ‘Table'[Column1])+1, 1)

It concatenates the first letter of the string, with the first letter found after the space.

If you have a name pattern like:
Jason A John, then you would need a different pattern.

——————————
Audrey Abbey
SR. BI Developer/Analyst
LeapFrogBI
Portland OR
——————————
——————————————-

[Mohamed Azarudeen]

Hi Thank you very much for your answer, i am using Direct query Model, Search option didn’t recognize in DAX formula.?

——————————
Mohamed Azarudeen
BI Developer
IV
chennai
9790777218
——————————
——————————————-

[Audrey Abbey]

Then you will need to make some effort to play around with the string functions in DAX and find something that will work with Direct Query.
FIND may work, if SEARCH doesn’t, but I have no way of reproducing your environment locally.

https://docs.microsoft.com/en-us/dax/text-functions-dax

——————————
Audrey Abbey
SR. BI Developer/Analyst
LeapFrogBI
Portland OR
——————————
——————————————-

[Mohamed Azarudeen]

Hi , Thank you very Much .i  will do it.

Thanks and Regards,
Azar.?

——————————
Mohamed Azarudeen
BI Developer
IV
chennai
9790777218
——————————
——————————————-