Forum Discussion
Concatenate String Values When Aggregating
I have data relating to product price changes on specific days:
| Date | Price Change | Product |
| 01/01/2017 | 2 | Prod1 |
| 01/01/2017 | 4 | Prod2 |
| 01/01/2017 | 3 | Prod3 |
What i need is an aggregated view of the data:
| Date | Total Price Change | Products Changed |
| 01/01/2017 | 9 | Prod1, Prod2, Prod3 |
The aim is that I can include the products that have change on a given day as a value in the tool tip of a sales line chart.
Is this kind of concatenation of string values possible; all i can manage to produce is the first or last product name, not a list of all three?
Hi Nickodemus,
This should work for you:
Create measures as follows
Measure = SUM(Sheet1[Price Change]) //you can create this or just use your Price Change and select SUM, up to you.
Measure 2 = CONCATENATEX(Sheet1,Sheet1[Product]&", ")
Regards
Abduvali
2 Replies
Hi Nickodemus,
This should work for you:
Create measures as follows
Measure = SUM(Sheet1[Price Change]) //you can create this or just use your Price Change and select SUM, up to you.
Measure 2 = CONCATENATEX(Sheet1,Sheet1[Product]&", ")
Regards
Abduvali
Perfect! Thanks Abduvali!
