Forum Discussion

JackWren's avatar
JackWren
Icon for Helper II rankHelper II
3 years ago
Solved

Add quotes around values - Concatenex()

Hi, 

I am using concatenex to retrieve several values from a filter. 

CONCATENATEX(VALUES(DIM_Products_Desc[Fruit]),DIM_Products_Desc[Fruit],",")
My result looks like this : banana,apple,peach 
 
However, I need the names to be in quotation marks : "banana","apple","peach" etc... 
Is there any way to do this? 
 
Thank you 🙂 
 
concatenex
DAX
  • OwenAuger's avatar
    OwenAuger
    3 years ago

    Hi JackWren 

    This should do the trick: a " character can be entered as two double-quote characters inside a string literal.   A single double-quote character therefore appears as four " in a row 🙂

    CONCATENATEX (
    VALUES ( DIM_Products_Desc[Fruit] ),
    """" & DIM_Products_Desc[Fruit] & """",
    ","
)

     

2 Replies

  • OwenAuger's avatar
    OwenAuger
    Icon for Super User rankSuper User
    3 years ago

    Hi JackWren 

    This should do the trick: a " character can be entered as two double-quote characters inside a string literal.   A single double-quote character therefore appears as four " in a row 🙂

    CONCATENATEX (
    VALUES ( DIM_Products_Desc[Fruit] ),
    """" & DIM_Products_Desc[Fruit] & """",
    ","
)