Make a measure that transforms a column of values to a list in text with a separator

[Anonymous]

Hi!

I need to make a measure that transforms a column of values to a text list with a separator.

Psuedo-code: Measure = "Combine to text" ( VALUES('Table'[Column]), ',')

[Table]

[Column]

a

b

c

Result: 'a, b, c'

It has to be a calculated measure,  since the data source is a SSAS tabular-cube, I cant do anything with power query or calculated columns.

Regards

Niklas

[Zubair_Muhammad · Accepted solution]

@Anonymous 

You can use CONCATENATEX

Measure =
CONCATENATEX ( VALUES ( 'Table'[Column] ), [Column], "," )

[Anonymous]

Thanks!

Unfortunately i wont work for me, because of the sql server version we have is to old. I found this post:

https://community.powerbi.com/t5/Desktop/CONCATENATE-greyed-out/m-p/207078#M91244

If anyone has a work around to achieve the same thing for SSAS with SQL server 2012, please comment.

---

@Zubair_Muhammad wrote:

@Anonymous 

You can use CONCATENATEX

Measure =
CONCATENATEX ( VALUES ( 'Table'[Column] ), [Column], "," )

---