Pull text from related table

[emccauley]

I have two tables and I am trying to find a formula that will allow me to pull the text over from a table that has duplicates to a table that does not. But I keep getting errors like "the value for column 'Name of Column' in table 'Name of Table' cannot be determined in the current context".

 

[ruve1k]

Do the tables have a relationship setup between them?

 

[emccauley]

Yes.

 

[ruve1k]

Have you tried the RELATED function? It should be pretty straightforward.
Can you provide samples of your tables?

 

[ruve1k]

I just reread your original question.

I am trying to find a formula that will allow me to pull the text over from a table that has duplicates to a table that does not.

If there are multiple values in the column in the table on that side of the relationship then what value do you want to show?

 

[emccauley]

Well it depends on which column I trying to pull over, but I don't really have a preference at the moment of which value. I just want something rather than #ERROR.

 

[ruve1k]

Try:

=CALCULATE(TOPN(1,VALUES(Table1[Col2]),Table1[Col2],1))

where I assume that Table1 has the duplicates and that Table1[Col2] is the column that you want to retrieve from Table1.

 

[emccauley]

"Failed to resolve name 'TOPN'. It is not a valid table or function name."

 

[ruve1k]

You need PowerPivot v2 for that function.
(SQL Server 2012 PowerPivot)