Lookup value multiple values

[Anonymous]

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 · Accepted solution]

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]

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.

[amitchandak]

@Anonymous , if join these two tables together on letter column, you can show them together in visual

or merge in power query Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query