Formula Calculation Help

[kjani]

Hello, can you help to calculate following? Here is my sample data:

Customer	Category	Name	Value
A	X	20 Revenue	50
A	X	20 Discount	10
A	X	21 Revenue	70
A	X	21 Discount	20

Calculate
21 Incremental Revenue = 21 Revenue - 20 Revenue = 70 - 50 = 20
21 Price realization = ((21 Revenue - 21 Discount) - (20 Revenue - 20 Discount)) / (21 Revenue - 20 Revenue) = 10/20 = 50%

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.