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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
im_newbie_123
Frequent Visitor

How to use related DAX function with concatenate

I have two tables (A and B).

 

Table A has 4 columns.

User ID                    First Name        Last Name      Preferred Name  

 

Table B has 1 column named User ID

 

I want to create a new column named Person Name in Table B based on User ID where I concatenate first name, last name and preferred name.

 

Example:

Table A 

User ID        First Name        Last Name      Preferred Name  

123                Sam                    John                  NULL

4351               Samuel              Hans                  Samu

 

Table B

User ID         Person Name

123                John, Sam

4351              Hans, Samuel (Samu)

 

Power BI creats a relationship between the Table A and Table B based on User ID

 

I understand I need to use related DAX function and concatenate the columns. 

can i get the correct syntax.

 

1 REPLY 1
Anonymous
Not applicable

@im_newbie_123 im_n

Column = CONCATENATE(CONCATENATE(RELATED(TableA[Last]),","),RELATED(TableA[First]))

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.