Forum Discussion

gomezc73's avatar
gomezc73
Icon for Helper V rankHelper V
2 years ago
Solved

How Concatenate Text by Category

Hi Experts,   I have the following issue.   I have in a table the explanations of variations by accounts.   Something like these:   Lead Account Sep 23 Sep22 VARIATION Explanation ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    gomezc73 I posted the formula in the original reply. All you should have to do is replace 'Table' with your actual table name assuming that your columns names are what you posted.

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

gomezc73 Try this. PBIX attached below signature.

Measure = 
    VAR __PathText = CONCATENATEX('Table', [Explanation], "|")
    VAR __Table = 
        ADDCOLUMNS(
            GENERATESERIES(1, COUNTROWS('Table'), 1),
            "__Text", PATHITEM(__PathText, [Value])
        )
    VAR __Result = CONCATENATEX(__Table, [Value] & " " & [__Text] & UNICHAR(10) & UNICHAR(13))
RETURN
    __Result