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