topic Re: Get one column values from one table to another table in DAX Commands and Tips

Get one column values from one table to another table

srivallyk — Tue, 27 Sep 2022 14:58:47 GMT

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

Re: Get one column values from one table to another table

tamerj1 — Tue, 27 Sep 2022 15:48:52 GMT

Hi srivallyk
which are the common columns?

Re: Get one column values from one table to another table

ribisht17 — Tue, 27 Sep 2022 16:28:06 GMT

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

Re: Get one column values from one table to another table

dnargade95 — Tue, 27 Sep 2022 19:20:57 GMT

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.

Re: Get one column values from one table to another table

v-yueyunzh-msft — Wed, 28 Sep 2022 02:40:28 GMT

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