Specific transformation on table

[weinerheineken]

Hi Everyone, as you can see below, I have data in the format in the "Initial Table" that I'd like to transform to the ones in the "Transformed Table".
Specifically, I'd like to group my data by order number but the resulting value should be a string in this format
<Quantity><Product>-<Quantity><Product>-...-<Quantity><Product>

But first sorted by Product.

Is there a way to perform this in PowerBi in Power Query, please?

[amitchandak · Accepted solution]

@weinerheineken , Create a measure

concatenateX(Table, Table[Product] & "-" & Table[Quantity], ",")

refer: Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

[weinerheineken]

Thank you very much. Technics in the YouTube video have been extremely useful.