Combine the data in row with comma

[kusanagi]

Hello,

I would like to know if we can do this in Power BI.

Here is the example of raw data:

And this is the result I need:

I was told combining rows is not possible, but still wanna ask the experts if there is a possibility to do this.

If this is possible, this would make everything easier.

[grazitti_sapna]

Hi @kusanagi 
Yes we can achieve this by ConcatenateX dax functions.
Please try using
Combined Items =
CONCATENATEX(
VALUES('Table1'[Category]),
CALCULATE(
CONCATENATEX('Table1', 'Table1'[Items], ", "),
ALLEXCEPT('Table1', 'Table1'[Category])
),
", ",
'Table1'[Category], ASC
)
Hope this will help you.
Thank you 

[kusanagi · Accepted solution]

Hi @grazitti_sapna ,

I solved the problem!

Thank you again!

Have a nice weekend!

[kusanagi]

Hi @grazitti_sapna ,

Appreciate for your help!

I would like to ask more detials about this formula.

I tried your formula in the Power BI, but it combine the whole column.

This shows in both report view and table view.

Which part of the formula should I edit?

Also, my raw data contain more than 20 columns, and I am only combining the information in [Item], the rest of the columns should remain the same.

Should I edit "ALLEXCEPT('Table1', 'Table1'[Category])" this part of the formula?

I tried to use FILTER, but everything shows error