Forum Discussion

adsam's avatar
adsam
Frequent Visitor
4 years ago
Solved

forecast by customer ratio

Hi Champions,    I have Sales data @ Product, Location, Week & Customer level and forecast data @ Product, Location, Week level   what I want is to get forecast * customer sales ratio . so forec...
Need Help
  • adsam's avatar
    adsam
    4 years ago

    thanks Ibendlin for your time and help. 

    below orange line I wanted

     

    I used below query and my issue resolved. 

    Forecast by Customer = VAR Allsales=CALCULATE(Sales_Trans[Sales],ALL(Customer),ALL('Calendar'))
                        VAR CusSales=CALCULATE(Sales_Trans[Sales],ALL('Calendar'))
                            Return DIVIDE(CusSales,Allsales)*[Forecast]

     

     

    File link:

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

That's what I provided on page 2? Are you looking for an extrapolation?

adsam's avatar
adsam
Frequent Visitor
4 years ago

thanks Ibendlin for your time and help. 

below orange line I wanted

 

I used below query and my issue resolved. 

Forecast by Customer = VAR Allsales=CALCULATE(Sales_Trans[Sales],ALL(Customer),ALL('Calendar'))
                        VAR CusSales=CALCULATE(Sales_Trans[Sales],ALL('Calendar'))
                            Return DIVIDE(CusSales,Allsales)*[Forecast]

 

 

File link: