How can I concatenate the result of VALUES([Column]) in a single text comma separated.

[javi0unavailabl]

How can I concatenate the result of VALUES([Column]) in a single text comma separated?

Thanks

[Greg_Deckler · Accepted solution]

Use CONCATENATEX

[Greg_Deckler · Accepted solution]

Use CONCATENATEX

[javi0unavailabl · Accepted solution]

Ok. Yesterday, I was using CONCATENATEX badly I think.

Syntax is

CONCATENATEX(<table>, <expression>, [delimiter]) 

I was using the entire table in <table> and VALUES([column]) in <expression> and it doesn't work.

Now, I tried using  VALUES([column]) in <table> and the [column] itself in expression and it works:

Measure = CONCATENATEX(VALUES(Table[column]);Table[column];", ")

Thanks for putting me on the way.

Regards

[Greg_Deckler]

Cool, glad you got there!

[Anonymous]

@Greg_Deckler@javi0unavailabl I've also used 

Measure = CONCATENATEX(Table,Table[column],", ")

But getting the same result as above. 

[Anonymous]

Hi @Greg_Deckler @javi0unavailabl Is there a way to do this for all values in a column. If I have column values [1,2,2,3,3], I should get 1,2,2,3,3 as the result. When I use the formula in the solution above, I get 1,2,3 as the result.
Thanks in Advance.