Forum Discussion

gomezc73's avatar
gomezc73
Helper 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
Community Champion
2 years ago

gomezc73 Sure, you can filter the blanks in the measure:

Explanation Measure = 
    VAR __PathText = CONCATENATEX(FILTER('Table', [Explanation] <> BLANK()), [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
gomezc73's avatar
gomezc73
Helper V
2 years ago

Hi,

 

 I tried but it still it show at the end blanks lines numbered.. See the image