Forum Discussion
Specific 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?
weinerheineken , Create a measure
concatenateX(Table, Table[Product] & "-" & Table[Quantity], ",")
refer: Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
2 Replies
weinerheineken , Create a measure
concatenateX(Table, Table[Product] & "-" & Table[Quantity], ",")
refer: Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
Thank you very much. Technics in the YouTube video have been extremely useful.
