DAX - combine first name and last name

[Markzolotoy]

I have a table with first names and last names I want to create a calculated table with a full name column. can that be done in one shot without creating two tables first?

Thanks

[amitchandak · Accepted solution]

@Markzolotoy , Try like. I have not tested this 

New Table =

addcolumns(summarize(Table, [First Name], [Last Name]), "Full Name" , [First Name] & " " & [Last Name])

[Jihwan_Kim · Accepted solution]

Hi, @Markzolotoy 

Please check the below.

new table =
SUMMARIZE (
ADDCOLUMNS (
'Table',
"full name",
'Table'[firstname] & " " & 'Table'[lastname]
),
[full name]
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous · Accepted solution]

HI @Markzolotoy,

You can try to use the following formula if it was suitable for your requirement.

NewTable =
SELECTCOLUMNS (
    ALL ( Table[First Name], Table[Last Name] ),
    "Full",
        [First Name] & " " & [Last Name]
)

Regards,

Xiaoxin Sheng

[Jihwan_Kim · Accepted solution]

Hi, @Markzolotoy 

Please check the below.

new table =
SUMMARIZE (
ADDCOLUMNS (
'Table',
"full name",
'Table'[firstname] & " " & 'Table'[lastname]
),
[full name]
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[amitchandak · Accepted solution]

@Markzolotoy , Try like. I have not tested this 

New Table =

addcolumns(summarize(Table, [First Name], [Last Name]), "Full Name" , [First Name] & " " & [Last Name])