Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
New2PowerBI
Helper III
Helper III

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],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. 

 

🙂

 

1 ACCEPTED SOLUTION
Phil_Seamark
Employee
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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

4 REPLIES 4
Phil_Seamark
Employee
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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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

paulag
Advocate I
Advocate 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 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.