Forum Discussion

New2PowerBI's avatar
New2PowerBI
Icon for Helper III rankHelper III
9 years ago
Solved

Concatenate Values (Where's Comma and Space)

I've concatenated values in Excel before but I can't seem to get a comma and space in between the values in Power BI.  Here is what I have: Employee Name = CONCATENATE(KPL_HISTORYROSTER_01[lastname]...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    You could try this :

     

    Employee Name = CONCATENATE(CONCATENATE('KPL_HISTORYROSTER_01'[lastname],", "),'KPL_HISTORYROSTER_01'[firstname]) 

     

    or

     

    Employee Name = 'KPL_HISTORYROSTER_01'[lastname] & ", " & 'KPL_HISTORYROSTER_01'[firstname]

     

    or

     

    Do the transform in the Query Editor as per the previous suggestion

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

You could try this :

 

Employee Name = CONCATENATE(CONCATENATE('KPL_HISTORYROSTER_01'[lastname],", "),'KPL_HISTORYROSTER_01'[firstname]) 

 

or

 

Employee Name = 'KPL_HISTORYROSTER_01'[lastname] & ", " & 'KPL_HISTORYROSTER_01'[firstname]

 

or

 

Do the transform in the Query Editor as per the previous suggestion

New2PowerBI's avatar
New2PowerBI
Icon for Helper III rankHelper III
9 years ago

Thank you!!  All suggested solutions worked; thanks again!

  • Claudio_Bastos's avatar
    Claudio_Bastos
    New Member
    6 years ago

    Utilizando o suplemento Power Pivot, no Microsoft Excel 2016, você pode fazer isto:

     

    =CONCATENATE(CONCATENATE('Tabela_1'[Campo_1];" - ");'Tabela_2'[Campo_2])

     

    Utilize aspas ( " ), ao invés de apóstrofo ( ' ).