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