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.
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?
Solved! Go to 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
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
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |