Forum Discussion

ARaniga's avatar
ARaniga
Frequent Visitor
10 years ago
Solved

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:...
Need Help
  • TheOckieMofo's avatar
    TheOckieMofo
    10 years ago

    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.

TheOckieMofo's avatar
TheOckieMofo
Resolver II
10 years ago

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.

  • ARaniga's avatar
    ARaniga
    Frequent Visitor
    10 years ago

    Great suggestions to start with.  Thank you.