Forum Discussion
gomezc73
2 years agoHelper V
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 ...
Greg_Deckler
2 years agoCommunity Champion
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
__Resultgomezc73
2 years agoHelper V
Hi,
I tried but it still it show at the end blanks lines numbered.. See the image