Forum Discussion

Hayleysea's avatar
Hayleysea
Icon for Resolver II rankResolver II
5 years ago
Solved

Merge text values from different rows into one row based on value in another column

Hi there, how can I achieve the below data transformation? The reason is I have two separate table with the same data structure that I need to compare using a matrix visual. At the moment the Type va...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Hayleysea,

    I'd like to suggest you write a measure formula to use a current category to look up correspond records and merge them into one and use it on matrix. It will show the expected result as you wanted.

    measure =
CALCULATE (
    CONCATENATEX ( VALUES ( Table1[Type] ), [Type], " " ),
    FILTER ( ALLSELECTED ( Table1 ), [Name] IN VALUES ( Table2[Name] ) )
)

    Regards,
    Xiaoxin Sheng

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Hayleysea , If you have common dimension Table  Name joined with Table A and Table B, Then this should work.