Forum Discussion

jonnyA's avatar
jonnyA
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

Conatenate First Name with Last Name

I'm looking for a New Measure that will Concatenate my First Name with Last Name.

Here are my Fileds.  Thank you in advance!

 

 

 

Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Really? Bizzare!!

    Ok here is a formula just change the name of table and column accordingly

    Concatenate =
    var _FirstName = SELECTEDVALUE(Consumer[consumerId])
    var _SecondName = SELECTEDVALUE(Consumer[client name])
    return
    CONCATENATE(_FirstName , CONCATENATE(" ", _SecondName))

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    jonnyA Perhaps:

    Name Measure = MAX('vw_Discharge_Dataset'[Patient_First_Name]) & " " & MAX('vw_Discharge_Dataset'[Patient_Last_Name])