Concatenate Values (Where's Comma and Space)

[New2PowerBI]

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],KPL_HISTORYROSTER_01[firstname])

The values I pull are good, just need to figure out how to insert a comma and space after the [lastname]; I've tried " " and & in the function but get errors. 

🙂

[Phil_Seamark · Accepted solution]

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]

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

[Claudio_Bastos]

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 ( ' ).

[paulag]

you can carry this step out in the query editor

add a custom column then the formula would be

KPL_HISTORYROSTER_01[lastname] &" , "&KPL_HISTORYROSTER_01[firstname]

This will yeild an M query that reads 

Table.AddColumn(#"Changed Type", "Custom", each [lastname]&" , "&[[firstname])

In the model you can also create a DAX column using the same as above.  Insert a custom column and use the formula(or expression) KPL_HISTORYROSTER_01[lastname] &" , "&KPL_HISTORYROSTER_01[firstname]

Hope that helps