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.
Hi Need Help I have two columns in my dataset one is finished good value and the other is compare finished good value I am calculating cost difference i.e., (finished good value- comapre good value) it give me cost difference now I want to calculate cumilative percentage for this.
The formula given to me to calculate cumilative perc is running sum(cost diff)/sum(cost diff) this formula is of SAP BO. Can any one help how can I get cummilative percentage
NOTE-: the power bi vierson is of 2017 so I cannot new quick measure.
Solved! Go to Solution.
Hi @afaque03,
Based on my test, you can refer to below steps:
1.I have entered some sample data to test for your problem like the picture below.
2.Create two calculated columns to calculate your cumulative growth value and now you can see the result.
Incrementalprofits =
SUMX (
FILTER (
'Product',
'Product'[differences] >= EARLIER ('Product'[differences] )
),
'Product'[differences]
)
IncrementalPcts =
DIVIDE (
'Product'[Incrementalprofits],
SUM ( 'Product'[differences] )
)
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/j4rutflhh7jy5y4/Cumilative%20Percentage.pbix?dl=0
Regards,
Daniel He
Hi @afaque03,
could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @afaque03,
Based on my test, you can refer to below steps:
1.I have entered some sample data to test for your problem like the picture below.
2.Create two calculated columns to calculate your cumulative growth value and now you can see the result.
Incrementalprofits =
SUMX (
FILTER (
'Product',
'Product'[differences] >= EARLIER ('Product'[differences] )
),
'Product'[differences]
)
IncrementalPcts =
DIVIDE (
'Product'[Incrementalprofits],
SUM ( 'Product'[differences] )
)
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/j4rutflhh7jy5y4/Cumilative%20Percentage.pbix?dl=0
Regards,
Daniel He
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |