Forum Discussion

James__'s avatar
James__
Icon for Helper I rankHelper I
4 years ago
Solved

Help in copying data from one table to another :-(

Hi,

 

I have 3 tables in my report:

 

Dates

Claims

Bodyshops

 

The bodyshop table contains [name], [code], [parent_company] etc... 

The claims table doesn't have the [parent_company] data. but does have the [code] in 2 separate columns (one for selling bodyshop, the other for repairing bodyshop (each dealer has an individual [code).

 

I'm trying to take the bodyshop table [parent_company] column and insert it to my claims table twice. Once to show the parent company of the seller, the second to show the parent company of the repairer. 

 

I have linked the table via the [code], but it only picks up the selling bodyshop [parent_company], not that of the repairer and i need it to show twice.

 

Can anyone help, please?

Thanks 

Need Help

3 Replies

  • James__'s avatar
    James__
    Icon for Helper I rankHelper I
    4 years ago

    My goal is to create this measure: IF(selling_bodyshop_parent_company = repairing_bodyshop_parent_company,1,0)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi James__ ,

     

    Please try these:

    parent_company_1 = RELATED('Bodyshops'[parent_company])
    parent_company_2 = LOOKUPVALUE('Bodyshops'[parent_company],'Bodyshops'[code],'Claims'[code_2])

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

    • James__'s avatar
      James__
      Icon for Helper I rankHelper I
      3 years ago

      Excellent, Gao! Thank you very much indeed.

       

      James