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

[James__]

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 

[Anonymous · Accepted solution]

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__]

Excellent, Gao! Thank you very much indeed.

James 

[James__]

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