web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 2

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)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,326 on at
    Is it possible to include a prediction column in a quantity-based sales forecast?
    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.*
  • Daniyal Khaleel Profile Picture
    Daniyal Khaleel 331 on at
    Is it possible to include a prediction column in a quantity-based sales forecast?
    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.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daniyal Khaleel Profile Picture

Daniyal Khaleel 116

#2
DAnny3211 Profile Picture

DAnny3211 91

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 66 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans