Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Relationships with missing data

Hi all. I need to create a relationship connecting table 1 and table 2.

If I create a link using only ID 1, some data will be lost. Likewise for ID 2.

Is there a way of using both ID 1 and ID in table 2 to link to Table 1?

Thank you

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    After splitting the first table. You may set the relationships as below. Then you may create a measure to get all the FirstName.

    UpdateFirstName =
IF (
    MAX ( '1(1)'[First Name] ) = BLANK (),
    MAX ( '1 (2)'[First Name] ),
    MAX ( '1(1)'[First Name] )
)

     

    Regards,

    Cherie 

4 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago
    Anonymous Hmm, you can split the first table into two separate tables (FirstName and ID1) (FirstName and ID2). Then link the table2 to these two tables by ID1 and ID2.
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Unfortunately your solution provides this. The first Name and Last name should show all data from both columns

      • v-cherch-msft's avatar
        v-cherch-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous

         

        After splitting the first table. You may set the relationships as below. Then you may create a measure to get all the FirstName.

        UpdateFirstName =
IF (
    MAX ( '1(1)'[First Name] ) = BLANK (),
    MAX ( '1 (2)'[First Name] ),
    MAX ( '1(1)'[First Name] )
)

         

        Regards,

        Cherie