Add quotes around values - Concatenex()

[JackWren]

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 🙂 

[OwenAuger · Accepted solution]

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] & """",
    ","
)

[JackWren]

Thank you so much ! It works beautifully