Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate dynamic forecast using historical data

Hello,   Please excuse me for summarizing and using improper formating in this message - I'm new to this!   (This is not about the forecast feature built-into Power BI visualizations)   I'm try...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Kindly try below measure:

    I use the [measureclose]and [measureopp] to represent the measure Close % and Opportunity total

    Forecasted Sales = [Measureclose]*[MeasureOpp]*MAX('Table (3)'[Age%])

     Then 

    SUMXForecast = SUMX(VALUES('Table (3)'[Month]),[Forecasted Sales])

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

 

Kindly try below measure:

I use the [measureclose]and [measureopp] to represent the measure Close % and Opportunity total

Forecasted Sales = [Measureclose]*[MeasureOpp]*MAX('Table (3)'[Age%])

 Then 

SUMXForecast = SUMX(VALUES('Table (3)'[Month]),[Forecasted Sales])