Forum Discussion

abhiiimr15's avatar
abhiiimr15
Frequent Visitor
8 years ago
Solved

DAX forum

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 IDProductCity of Manufacturing
1PenDelhi
2PencilMumbai
3PaperNoida
4EraserDelhi
5NotebookMumbai
6RulerMumbai
7MarkerNoida
8SharpnerDelhi
9PinsNoida
10Pencil boxNoida

 

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

City of ManufacturingProduct
DelhiEraser,Pen, Sharpener
MumbaiNotebook,Pencil,Ruler
NoidaMarker, Paper, Pencil box, Pins

 

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

Need Help

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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?