How to use related DAX function with concatenate

im_newbie_123 — Thu, 24 Oct 2019 15:03:17 GMT

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.

Re: How to use related DAX function with concatenate

Anonymous — Fri, 25 Oct 2019 03:59:13 GMT

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