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

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

 

 

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!

1 Reply

  • 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!