Forum Discussion
jonnyA
Responsive Resident
Responsive ResidentConatenate 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!
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])returnCONCATENATE(_FirstName , CONCATENATE(" ", _SecondName))
6 Replies
- Greg_Deckler
Community Champion
jonnyA Perhaps:
Name Measure = MAX('vw_Discharge_Dataset'[Patient_First_Name]) & " " & MAX('vw_Discharge_Dataset'[Patient_Last_Name])
