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