Looking up values from another table

[Anonymous]

Hi

I have two tables. both have a master column called Name and a relationship exists between the name columns. 

each table has a values column. 

in Table 1 I want to add a column that looks up the value in Table 2 if the names in the name columns are the same. 

i've tried lookupvalue with the following syntax

Util = LOOKUPVALUE('table2'[value],'table2'[Name],'Table1'[Name])

however it only retuns one value for a cell called Blank. yet I know for a fact the names in the columns are the same. 

can anyone help with this?

thanks

[Arul]

Hi @Anonymous ,

Have you tried RELATED function to calculate this column.

Thanks,

-Arul

[Anonymous]

can you help with what the syntax would look like with using related? everytime I try to use it i get errors.

[Anonymous]

I just tried entering measure=RELATED('Table2'[Value]) and I got an error. there is a 1:1 relationship in place yet it doesn't appear to recognise the relationship

[v-lili6-msft]

hi, @Anonymous 

You need to use these formula to add a column instead of a measure.

And usually, these two formula should work well. there may be something wrong in another way.

If still has this issue, please share your simple sample pbix file for us to have a test.

Best Regards,

Lin