Forum Discussion
Solved
Get column from another table
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
Hi srivallyk
Sorry, seems somehow I missed your reply. Apologies for the late response. Please useProgram Name = VAR T1 = ADDCOLUMNS ( 'Project Programme', "@ProgramName", RELATED ( Programme[ProgrammeName] ) ) VAR T2 = FILTER ( T1, 'Project Programme'[ProgrammeKey] = Project[ProjectKey] ) RETURN MAXX ( T2, [@ProgramName] )
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.
