Forum Discussion
Baseline Sales vs Incremental Sales
Hi,
We currently have sales data structured as below:
1. Date
2. Brand
3. Price
4. Units sold
5. Promotion (yes/no) based on if price is < or > 3.70
What we would like to achieve:
1. Baselines sales is unit sales on previous date where promotion is no
2. Incremental sales is unit sales less baseline sales
This solution would be helpful to a lot of marketers out there.
Help appreciate.
Regards,
AR
You would use the Earlier function for this. I believe you would need two calculated columns.
1. For baseline sales, make a calculated column that is:
=CALCULATE( [Price] * [Units Sold] , FILTER('Table Name','Table Name'[Date]=EARLIER('Table Name'[Date])-1)) , _
FILTER('Table Name','Table Name'[Brand]=EARLIER('Table Name'[Brand])-1)))
This will get you yesterday's sales by brand. You could also add a filter to exclude any promo pricing from yesterday.
2. Next you should be able to take your unit sales (price * units sold) for the current day and subtract this column to get the incremental sales.
Hope that helps and good luck.
2 Replies
You would use the Earlier function for this. I believe you would need two calculated columns.
1. For baseline sales, make a calculated column that is:
=CALCULATE( [Price] * [Units Sold] , FILTER('Table Name','Table Name'[Date]=EARLIER('Table Name'[Date])-1)) , _
FILTER('Table Name','Table Name'[Brand]=EARLIER('Table Name'[Brand])-1)))
This will get you yesterday's sales by brand. You could also add a filter to exclude any promo pricing from yesterday.
2. Next you should be able to take your unit sales (price * units sold) for the current day and subtract this column to get the incremental sales.
Hope that helps and good luck.
Great suggestions to start with. Thank you.
