Forum Discussion
Solved
Combine the data in row with comma
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 s...
grazitti_sapna
Super User
Super UserHi 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