Forum Discussion

srivallyk's avatar
srivallyk
New Member
3 years ago
Solved

Get one column values from one table to another table

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...
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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's avatar
dnargade95
New Member
3 years ago

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.