Forum Discussion
JOSERB
6 years agoFrequent Visitor
Calculated column with values from another table
Hi all, I need your help for a relatively simple topic, but I cannot make it work as I would like to. The goal is to add a calculated column from a table 2 into table 1, which are already con...
- 6 years ago
Hi JOSERB ,
Have you tried to change the ID column of Table 2 to the text category to create a relationship?
After I try to do this, I can get the expected result based on the sample data provided by you by using the related function.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-lianl-msft
6 years agoCommunity Support
Hi JOSERB ,
Have you tried to change the ID column of Table 2 to the text category to create a relationship?
After I try to do this, I can get the expected result based on the sample data provided by you by using the related function.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.