Answers for "power BI DAX get person initial"

0

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)
Posted by: Guest on November-05-2020

Browse Popular Code Answers by Language