Create variable from another table

[Jeremy19]

Hi,

I would like to create a variable from another table, for example:

Table A        

Var1      ord

A           1

A           1

B           2

A           1

Table B

Var1      ord

A          1

B          2

There is a relation between the two tables with Var1 and I would create the variable ord of table A using table B. Or just sort Var1 from table A from the variable ord of table B but I don't think it's possible. Someone can help me ?

Thanks !

[Zubair_Muhammad · Accepted solution]

Hi @Jeremy19

You can use this column in Table A

Ord= RELATED(TableB[Ord])

[Jeremy19]

Perfect ! Thanks