Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to add column from another table based on condition

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 Cu...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    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!

v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

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!