Create a concatenate column from different tables - ADD A NEW COLUMN ON A TABLE VISUALIZATION

[Anonymous]

Hi!

 I have 3 tables: Table A, Table B and Table C

On Table A I have 2 columns: (1) Names and their (2) Roles

On Table B I have 2 columns: (1) Courses and (2) Roles (assigned to each courses)

On Table C I have 2 columns: (1) Course-Names and (2) Exceptions

As this example:

On PowerBi I created a Visualization Table  making a relationship between Tables A & B throw column "Role". I have to add the column "Exception" of Table C to that visualizated table .

Any ideas on how to do it?

On excel I would create a Concatenated Column whit the Visualization Table between columns Course and Name, and then I would do a VLookup to add the "Exception" column. How could I do it on Power Bi?

[amitchandak]

@Anonymous , Not very clear, refer if this can help

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

Maybe this can help: