Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ( V...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

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

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

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

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Greg see the error, Much Apprecaited for the feedback.