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
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

Forum Discussion

Concatenate Values (Where's Comma and Space)

Related content

Concatenate EXCEPT where blank

concatenate values

Concatenate rows values

Total Min/Max measure where and keep the value static

Concatenate lists ;