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

paulag's avatar
paulag
Icon for Advocate I rankAdvocate I
9 years ago

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