Add new column by using another table's reference column

[Anonymous]

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.

[sevenhills · Accepted solution]

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!