Concatenate String Values When Aggregating

[Nickodemus]

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?

[Abduvali · Accepted solution]

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

[Nickodemus]

Perfect! Thanks @Abduvali!