Forum Discussion
Add new column by using another table's reference column
I have two table like below: A: Reference Table which gives 96% threshold against each type of container. Container Type Target Figure (96%) MX-1100 19 MW-2908 18 AD-1183 19.6 ...
Assuming you have the relationship as like this
Add a column to the transaction table as
Target Figure = RELATED('Reference Table'[Target Figure (96%)])Hope this helps!
Assuming you have the relationship as like this
Add a column to the transaction table as
Target Figure = RELATED('Reference Table'[Target Figure (96%)])
Hope this helps!