group
1 TopicSpecific transformation on table
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?Solved761Views0likes2Comments