Programming language:Whatever

2021-07-27 21:44:56

0

Q:

power BI DAX get person initial

Code: Whatever

2021-07-14 20:58:21

If the initial appears first in the full name:

FirstInitial = LEFT('Clients'[ClientFullname],1)

-----------------------------------------------------------------------------

If your full name contains a title:
Extract the title and store in 'Clients'[Title] then in DAX,

FirstInitial = LEFT(SUBSTITUTE('Clients'[ClientFullname],'Clients'[Title]&" ",""),1)

0

New to Communities?

Join the community