Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Return a concatenated string value based on calculation

Greetings everyone! I need help with the following moment:   There are 2 columns: 1) Say the first column is a name of product  2) Second column is a part that belongs to a...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    Please try

    =
VAR CurrentProject =
    SELECTEDVALUE ( TableName[Name] )
VAR CurrentPartTable =
    CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[Part #] ) )
RETURN
    IF (
        COUNTROWS ( CurrentPartTable ) = 1,
        CurrentProject,
        CONCATENATEX ( CurrentPartTable, TableName[Name], ", ", TableName[Name], ASC )
    )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 
Do you want to create a measure or a calculated column? Can you share the same sample data as copy/paste?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

A measure would be more preferrable. I guess it's going to take a couple of variables to make it. Unfortunately, I can't send the data because I have no rights....