How to Concatenate a colum with the last name and a colum with the first name

[Anonymous]

Hello Everyone , 

I have two columns , one with first name and an other with the last name , I want to concatenate the two columns in order to have a colum with the last name and the first lettre of the first name .

For example if the Last name is " Smith" and the first name is "Will" , I want as a result Smith W as a result .

Thanks in advance for your help ! 

[Varun8492]

Well, @Anonymous  you can try this if I understand your question correctly.

Full Name = CONCATENATE([Last Name], " ", LEFT([First Name], 1))

Now, you should have a new column called "Full Name" that contains the concatenated values of the last name and the first letter of the first name. You can use this new column in your visuals and calculations as needed.

[Anonymous]

Hello , thanks for your response . The function that you wrote is a DAX function and I want here , the syntax in Power Query 

[DOLEARY85]

You can still use columns created in power query in your visuals, however if you'd rather create a new column in the report view you can use:

Full Name= 'Table'[last name] & " " & left('Table'[first name],1)

[Anonymous]

Hello ,

Thanks for your help but It doesn't work , is the opposite ( First Name + first letter of last name ) has another synthax or not ?

[DOLEARY85 · Accepted solution]

sorry, so you want first name and first letter of last name?

which would be: = [first] & " " & Text.Start([last],1)

[Anonymous]

Hello , can i see the resullt of your query on your table created ? Thanks 

[DOLEARY85]

the M query code is

#"Added Custom" = Table.AddColumn(#"Changed Type", "split", each [first] & " " & Text.Start([last],1)),

[DOLEARY85]

Hi, 

I'd do this in power query, create a custome column with the following:

= [last name] & " " & Text.Start([first name],1)