Forum Discussion
Calculate difference of % between two rows
Hello Community, I tried to find through the forums a solution to my problem. So the "recovery Service Level" is a created measure that calculate the Lines Shipped cumulative divided by the Sum o...
Hi Anonymous ,
If you are looking for calculating the Service Line Added, you can simply use the below measure.
Service Line added = DIVIDE ( SUM ( 'Table' [Lines Shipped])) , 26303)
You do not need to find the row difference in this case.
Mathematical function, you are Calculating [(23593+412)/26303] - (23593/26303) . This translates to 412/26303.
Hope I was able to explain this.
Attaching an excel screenshot for the same.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!