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 need to calculate the growth or decrease based on the first and last record.
I have no idea. Bring data from one column based on another. When I say this, it is because I understand that I should bring the "QTY" column based on MIN (vdata) and MAX (vdata) and this I am not able to do with the little knowledge I have.
name | vdata | qty |
name a | 01/01/2017 | 10 |
name a | 10/10/2017 | 15 |
name a | 11/11/2017 | 20 |
name b | 02/02/2017 | 10 |
name b | 04/04/2017 | 14 |
name b | 05/05/2017 | 8 |
name c | 08/08/2017 | 10 |
name c | 09/09/2017 | 32 |
name c | 05/05/2017 | 42 |
----------------------------------
Example "Name A":
First reading: 01/01/2017
Value: 10
Last reading: 11/11/2017
Value: 20
-> Positive Result: 100%
----------------------------------
Example "Name B"
First reading: 02/02/2017
Value: 10
Last reading: 11/11/2017
Value: 8
-> Negative Result: (- 20%)
----------------------------------
In the past I simply calculated using MIN (qty) and MAX (qty). But sometimes between falls and uploads the data comes in incorrectly. GROWPERCENT = ((MAX(qty) - MIN(qty))/ MIN(qty)
I appreciate the help.
Solved! Go to Solution.
Hi,
Use this measure
Growth := CALCULATE ( VALUES ( Table1[qty] ), FILTER ( Table1, Table1[vdata] = MAX ( Table1[vdata] ) ) ) / CALCULATE ( VALUES ( Table1[qty] ), FILTER ( Table1, Table1[vdata] = MIN ( Table1[vdata] ) ) ) - 1
Hi,
Use this measure
Growth := CALCULATE ( VALUES ( Table1[qty] ), FILTER ( Table1, Table1[vdata] = MAX ( Table1[vdata] ) ) ) / CALCULATE ( VALUES ( Table1[qty] ), FILTER ( Table1, Table1[vdata] = MIN ( Table1[vdata] ) ) ) - 1
Hi @Zubair_Muhammad thanks a lot.
I just tested and it worked perfectly!!
When the person has the knowledge, everything is easier, right?
Thank you very much.
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |