Get one column values from one table to another table

[srivallyk]

Hi Experts,

I have two tables with one common column with no active relationship, but I want to retrieve column from on table to other table. Can anyone help me on this.
https://www.dropbox.com/s/zteg09gkeyw07hn/Test.pbix?dl=0
I have attached test file, I want LegalEntityLevel column to Project table.

Thanks in Advance.

Regards,
Srivally

[v-yueyunzh-msft · Accepted solution]

Hi, @srivallyk 

According to your description, you want to get a column from other table and the two tables have no relationship. Right?

You can create a calculated column in 'Project' table.

Level = LOOKUPVALUE('Legal Entity'[Legal Entity Level],'Legal Entity'[Legal Entity Name],'Project'[ProjectName])

Then you can get the level in 'Legal Entity' table.

For this dax function, you can refer to :

LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[dnargade95]

hello, 

i saw your file .

step to follow.

1 create relationship from both table there are two commen column on this table. but if this table does not have simiar value then do sertain transition on referance and duplicate and then create relationship.

2 mearge thoes two column .

3 select column whatever you want.

thanks.

[ribisht17]

@srivallyk 

How to Relate ?

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

Please provide more information here if you need more help

Regards,

Ritesh

[tamerj1]

Hi @srivallyk 
which are the common columns?