Forum Discussion

srivallyk's avatar
srivallyk
New Member
3 years ago
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
  • tamerj1's avatar
    tamerj1
    3 years ago

    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's avatar
srivallyk
New Member
3 years ago

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's avatar
tamerj1
Community Champion
3 years ago

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

  • srivallyk's avatar
    srivallyk
    New Member
    3 years ago

    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's avatar
      tamerj1
      Community Champion
      3 years ago

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