topic Re: Add quotes around values - Concatenex() in DAX Commands and Tips

Add quotes around values - Concatenex()

JackWren — Tue, 25 Jul 2023 15:52:33 GMT

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 🙂

Re: Add quotes around values - Concatenex()

OwenAuger — Tue, 25 Jul 2023 20:41:09 GMT

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

Re: Add quotes around values - Concatenex()

JackWren — Wed, 26 Jul 2023 08:22:55 GMT

Thank you so much ! It works beautifully