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 |
B: Transaction table which shows total weight filled in each container
| Transaction Id | Type | Weight |
| 1 | MX-1100 | 18.3 |
| 2 | MW-2908 | 17.4 |
| 3 | AD-1183 | 17.9 |
| 4 | MX-1100 | 16.5 |
I would like table B to get a new column as target against the Types, so I can subtract the Weight with Target and see which transaction is below the threshold.
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!
1 Reply
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!