Forum Discussion

Nickodemus's avatar
Nickodemus
Helper III
8 years ago
Solved

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 aggreg...
Need Help
  • Abduvali's avatar
    Abduvali
    8 years ago

     

    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

     

     

Abduvali's avatar
Abduvali
Skilled Sharer
8 years ago

 

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