Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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 , 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |