How to work with arrays in PowerBI?

[Anonymous]

Hello

I have the data below:

A, 1

A, 2

A, 3

B, 1

B, 2

How can I specify the array for Column2 per value of Column1 and output it into a comma separated string in ascending order?

I.e.:

A; 1,2,3

B; 1,2

Thanks!

[AlB]

Hi @Anonymous 

1. Place Col1 on a table visual

2. Place this measure in the visual 

Measure =
CONCATENATEX ( DISTINCT ( Table1[Col2] ), Table1[Col2], "," )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Anonymous]

Thanks, what is the orderby expression for ascending order please?

[AlB · Accepted solution]

@Anonymous 

Measure =
CONCATENATEX ( DISTINCT ( Table1[Col2] ), Table1[Col2], ",", Table1[Col2], ASC  )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[amitchandak]

@Anonymous , You can create a measure on second column

new measure = concatenatex(Table, Table[Col2])