Forum Discussion
New2PowerBI
Helper III
Helper IIIConcatenate 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]...
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
New2PowerBIHelper III
Helper IIIThank you!! All suggested solutions worked; thanks again!
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 ( ' ).