Forum Discussion
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...
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
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.
Unfortunately your solution provides this. The first Name and Last name should show all data from both columns
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
Using your method, will I have to create a new measure for every subsequent column e.g.
UpdateFirstName, UpdateEyeColour,UpdateShoeSize etc?
Many thanks