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.

     

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.