Forum Discussion
First Name , Mid Name & Last name Split.
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.
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.
1 Reply
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.