power BI DAX get person initial code example

Example: power BI DAX get person initial

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)