First Name , Mid Name & Last name Split.

[Anonymous]

Dear All,

I need your support for a query about Name split, I have set of Full Name in which i have to split First Name, Mid Name & Last Name.

for First Name and Mid Name fourmula is working fine but for Last Name if i am applying the Dax fourmula then its considering First Name as a last Name. kindly find the snap shot below.

[v-tangjie-msft · Accepted solution]

Hi  @Anonymous ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.

(2) We can create two calculated columns.

Flag = IF( ISERROR( SEARCH(" ", 'Table'[Full Name]) ), 0, 1 )

correct Last Name = IF('Table'[Flag]=0,BLANK(),'Table'[Last Name])

(3) Then the result is as follows.

(4)Or you can click "Transform Data" to enter the Power Query editor and split the column according to the following operations.

Refer this: Split first, middle and last name in Power BI Desktop - YouTube

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.