Forum Discussion

JackWren's avatar
JackWren
Helper 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  ...
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] & """",
    ","
)

     

OwenAuger's avatar
OwenAuger
Super 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] & """",
    ","
)

 

  • JackWren's avatar
    JackWren
    Helper II
    3 years ago

    Thank you so much ! It works beautifully