DAX forum

[abhiiimr15]

I am new to th PowerBI, and i have a requirement where in I want to show my output (names of products) in a single cell separated by a delimiter (comma, lets say).

For e.g. my input data set is :

Prod ID	Product	City of Manufacturing
1	Pen	Delhi
2	Pencil	Mumbai
3	Paper	Noida
4	Eraser	Delhi
5	Notebook	Mumbai
6	Ruler	Mumbai
7	Marker	Noida
8	Sharpner	Delhi
9	Pins	Noida
10	Pencil box	Noida

And the Output I expect is a simple table in the follwoing fashion:

City of Manufacturing	Product
Delhi	Eraser,Pen, Sharpener
Mumbai	Notebook,Pencil,Ruler
Noida	Marker, Paper, Pencil box, Pins

Please help me with the appropriate DAX, or even M query would do. 

[Anonymous]

Using Dax.do - however facing this issue when executing this query. I'm not sure what the problem is that I get this error. It's a simple query too. 

Is this a bug issue within the application? 

[v-juanli-msft]

Hi @abhiiimr15

Based on my test, Zubair_Muhammad's formula can help, if you have any question, please feel free to ask me.

Best Regards

Maggie

[Zubair_Muhammad · Accepted solution]

@abhiiimr15

Try this MEASURE

Measure =
CONCATENATEX ( VALUES ( Table1[Product] ), [Product], ", " )