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 :  ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    abhiiimr15

     

    Try this MEASURE

     

    Measure =
CONCATENATEX ( VALUES ( Table1[Product] ), [Product], ", " )
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