Get column from another table

[srivallyk]

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

[srivallyk]

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

[tamerj1 · Accepted solution]

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] )

[srivallyk]

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.

[tamerj1]

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

[srivallyk]

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.

[tamerj1]

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

[tamerj1]

Hi @srivallyk 
Please provide more information.