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

Get column from another table

srivallyk — Mon, 19 Sep 2022 09:45:17 GMT

Hi Experts,

I have a scenario like need to retrieve a column from one table to other table which we do not have any relation among each tables.
Can anyone help me on this.

Regards,
Srivally

Re: Get column from another table

tamerj1 — Mon, 19 Sep 2022 10:08:56 GMT

Hi srivallyk
Please provide more information.

Re: Get column from another table

srivallyk — Mon, 19 Sep 2022 11:28:55 GMT

Hi tamerj1 , I have attached the data model.
Here I want ProgrammeName from Programme Table to Project Table.
https://www.dropbox.com/s/tm3orr9kpqvlatt/Test.pbix?dl=0

Re: Get column from another table

tamerj1 — Mon, 19 Sep 2022 16:44:39 GMT

Hi srivallyk
Sorry, seems somehow I missed your reply. Apologies for the late response. Please use

Program Name = VAR T1 = ADDCOLUMNS ( 'Project Programme', "@ProgramName", RELATED ( Programme[ProgrammeName] ) ) VAR T2 = FILTER ( T1, 'Project Programme'[ProgrammeKey] = Project[ProjectKey] ) RETURN MAXX ( T2, [@ProgramName] )

Re: Get column from another table

srivallyk — Thu, 29 Sep 2022 09:38:00 GMT

But if I have multiple Programme Names for one Project, I'm getting only one Programme Name. I need to show either all Programme Names under that Project or simply show '-' for the Project.

Re: Get column from another table

tamerj1 — Thu, 29 Sep 2022 09:54:22 GMT

Hi srivallyk
Please update the sample file to reflect the same and share it with me.

Re: Get column from another table

srivallyk — Thu, 29 Sep 2022 11:22:27 GMT

Hi tamerj1
attached is the link for the file.
https://www.dropbox.com/s/3jrlh7un2ev3hgd/Test_Card.pbix?dl=0
Here in the attached data model, relationships are not created because it cannot be created originally there are other datasets which I have not included.
If I select Project from the slicer, respective Programe and Legal Name should dispaly under respective cards. If I have multiple program/Legal Name under one Project selection, it should display '-' in card.

Re: Get column from another table

tamerj1 — Thu, 29 Sep 2022 12:49:25 GMT

srivallyk
I can see that you've already done that successfully. Am I missing something?