Forum Discussion
Dynamic Title Using Concatenate
Hi Experts
I not sure what my error is here. I am trying to add the text "by Franchises" to the end of the following Dynamic Title Measure...
DynamicTitle =
""
& CONCATENATEX (
VALUES ( 'Management'[Level4] ),
'Management'[Level4],
"," & CONCATENATE("dsfsf!")
)
Hmm, I don't think you need that last CONCANTENATE and I don't think that you want your delimiter to be ", dsfsf!". Perhaps:
DynamicTitle = "" & CONCATENATEX ( VALUES ( 'Management'[Level4] ), 'Management'[Level4], ",") & "dsfsf!"CONCATENATEX(<table>, <expression>, [delimiter])
2 Replies
Hmm, I don't think you need that last CONCANTENATE and I don't think that you want your delimiter to be ", dsfsf!". Perhaps:
DynamicTitle = "" & CONCATENATEX ( VALUES ( 'Management'[Level4] ), 'Management'[Level4], ",") & "dsfsf!"CONCATENATEX(<table>, <expression>, [delimiter])