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 possible to create an column with multiple returns like below?

 

Table: "Data"

Table: "Quantities"

 

The outcome what I need is this:

Is this possible in Power BI? 

Thanks in advance.

  • 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.

     

3 Replies

  • 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.

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    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.