Forum Discussion

Helper 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. b...

Need Help

Anonymous
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
Help in copying data from one table to another.pbix21 KB

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

Help in copying data from one table to another.pbix21 KB