How grouping text fields with same number in another column?

[citizenbh]

Is it possible to do this in DAX
Quantity	Product		Quantity	Products
5	A		5	A, E
2	B	->	3	C
3	C		2	B, D, F
2	D
5	E
2	F

<tbody>
</tbody>

 

[anvg]

Hi
In Excel 2016 and Power BI Desktop you can use

SUMMARIZE('Table1', 'Table1'[Quantity], "Products", CONCATENATEX('Table1', 'Table1'[Product], ", "))

Regards,

 

[citizenbh]

Thank you for your prompt reply, but can the more detailed explanation for Excel 2016, please

 

[citizenbh]

After entering:

measure1:=SUMMARIZE('Table1'; 'Table1'[Quantity]; "Products"; CONCATENATEX('Table1'; 'Table1'[Product]; ", "))

I have error:

Calculation error in measure 'Table1'[measure 1]: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

 

[anvg]

I thought you want a virtial table. Alright for measure simple use

Products:=CONCATENATEX('Table1'; 'Table1'[Product]; ", ")

 

[citizenbh]

I've changed your proposal and working

=CONCATENATEX(
    SUMMARIZE('Table1','Table1'[Quantity], Table1[Product]),
    'Table1'[Product], ", ")

This above is much simpler
Thanks again