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/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'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

     

4 Replies

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

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    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