Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Nickodemus
Helper III
Helper III

Concatenate String Values When Aggregating

I have data relating to product price changes on specific days:

DatePrice ChangeProduct
01/01/20172Prod1
01/01/20174Prod2
01/01/20173Prod3

 

What i need is an aggregated view of the data:

DateTotal Price ChangeProducts Changed
01/01/20179Prod1, 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?

1 ACCEPTED SOLUTION
Abduvali
Skilled Sharer
Skilled Sharer

 

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]&", ")

Capture.PNG

Regards

Abduvali

 

 

View solution in original post

2 REPLIES 2
Abduvali
Skilled Sharer
Skilled Sharer

 

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]&", ")

Capture.PNG

Regards

Abduvali

 

 

Perfect! Thanks @Abduvali!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.