Forum Discussion
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],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.
:-)
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
5 Replies
- Phil_Seamark
Microsoft Employee
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
New2PowerBIThank 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 ( ' ).
paulagAdvocate I
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
- This works for mefirstandlast = CONCATENATE([Driver First Name]," "&[Driver Last Name])
