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