Forum Discussion
James__
Helper I
3 years agoHelp 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. b...
- Anonymous3 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 TeamIf 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__
Helper I
3 years agoMy goal is to create this measure: IF(selling_bodyshop_parent_company = repairing_bodyshop_parent_company,1,0)