web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Is it possible to incl...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Is it possible to include a prediction column in a quantity-based sales forecast?

(0) ShareShare
ReportReport
Posted on by OT-15090228-0 17

Hi everyone,

 

I’ve configured a sales forecast in Dynamics 365 based on quantity instead of revenue.

However, I noticed that the prediction column (which typically appears in revenue-based forecasts) is missing in this setup.

Is it possible to include a prediction column in a quantity-based sales forecast?

If so, could anyone guide me on how to enable or configure it properly?

 

Thanks in advance for your help!

Categories:
Dynamics 365 Sales
I have the same question (0)
  • Daniyal Khaleel Profile Picture
    Daniyal Khaleel 764 Most Valuable Professional on at
    No ,you cannot enable the OOB AI prediction column for quantity-based forecasts in Dynamics 365 Sales. Prediction is only available for revenue forecasts. To get prediction for quantity, you’d need to extend with custom AI or calculated columns.
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,417 Super User 2026 Season 1 on at
    Hi,
    In Dynamics 365 Sales, the **prediction column** in forecasts is available by default for revenue-based forecasts when predictive forecasting is enabled. However, for **quantity-based forecasts**, the prediction column is not currently supported out of the box. The predictive forecasting feature is designed to work with revenue metrics and does not extend to quantity-based forecasts as of now.
    If predictive insights on quantities are essential for your scenario, you might consider:
    - Creating a **custom calculated column** using Power Automate or Power Apps to estimate or predict quantities based on historical data.
    - Using **Power BI** to build a separate predictive model and visualize the results alongside your forecast.
    You can find more details in the official documentation on predictive forecasting in Dynamics 365 Sales.
     
    Please verify if this clarifies the current capabilities and possible alternatives.
    Thanks and best regards,  
    Daniele  
    *Note: This response was prepared with support from Copilot to ensure clarity and completeness.*
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at
    No, the prediction column is only available for revenue-based forecasts in Dynamics 365 Sales today.

    Forecast predictions are powered by AI models that work with the revenue field on opportunities. If your forecast is based on quantity, the prediction column will not appear because the model does not generate predictions for quantities.
    If you still need AI-based projections for quantity, you have two options:
    > Use a custom AI model (Azure ML or Power BI predictive model) to predict quantities and write those predictions back to a custom field on the opportunity. You can then include that field in your quantity-based forecast layout.
    > Switch the forecast back to revenue-based if you want to use Microsoft’s built-in AI prediction column.
     
    Thanks
    Rishabh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
11manish Profile Picture

11manish 176

#2
ManoVerse Profile Picture

ManoVerse 149 Super User 2026 Season 1

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 57 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans