A table of multiple values was supplied where a single value was expected

[InsightSeeker]

I have multiple code in my data (Table 1) and I want to retrieve the first (Name) from Table 1 and place it in my Table 2.

When I use lookcolumnvalue I get an error message “A table of multiple values was supplied where a single value was expected”. How can I handle this?

COLUMN =  LOOKUPVALUE(TABLE 2 [NAME],TABLE 1[CODE] ,TABLE [2 CODE])

TABLE 1

Code	Name
1	Apple
1	Apple
1	Apple
1	Apple
2	Banana
2	Banana
2	Banana
3	Grapes
4	Berry
5	Carrot
6	Mango
7	Curd
7	Curd
7	Curd

TABLE 2

Code	Name
1
1
1
1
2
2
2
3
4
5
6
7
7
7

[Tahreem24]

@InsightSeeker Create a NameColumn like this:

NameColumn = LOOKUPVALUE(Table1[Name],Table1[Code],Table2[Code])

[Greg_Deckler · Accepted solution]

@InsightSeeker Try using MAXX( FILTER( ... ), ... ) instead