Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Lookup value multiple values

Hello,   Can somebody tell me if this is possible in Power BI?   I have two tables and I want to use a lookup to find a value, but the problem is that there are multiple return values. Is it poss...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

     

     

    Name CC = 
RELATED(Data[Name])

     

    It is for creating a new column.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,
If you want to go for Lookup, you can create a calculated column in the Quantities table using the following DAX

Name Lookup Column = 
LOOKUPVALUE(
    Data[Name],
    Data[Letter],
    Quantities[Letter]
)

This will give the following result.

But for better performance you should create a relationship between the Data and Quantities table in the data model and use RELATED() function. Or directly drag them in a visual as told by Amit.

Regards.