How to add column from another table based on condition

[Anonymous]

I have following tables connected to each other. Both of them are connected via Job Name. 

Now I want to bring Client Name from JobData table to Shippping Data Table if Job Name matches means

Custom Column = If Shipping_Data[Job Name] = JobData[Job Name] Then JobData[Client Name] else ""

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

From the pic you show,the relationship between the 2 tables is one to many.

If so ,create a column as below:

Column = CONCATENATEX(FILTER('JobData','JobData'[Job name ]='Shipping_Data'[Job name]),[Client Name],",") 

And you will get all matched values.

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my raeply as a solution!