Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

Forecast the Average performance from the past data based on vendor

Hi Team,

I would like to predict the average forecast performance of the vendors based on the lot number. (where the products are manufactured).


I can have the historical performances from the manufacturing date. How to estimate for the rest of the years productions based on the historical data. The data is also categorized under the quality of the outcome.




The attached image is the current data, looking to forecast for the same as next column or a separate one

Any suggestions will be much appreciated, thanks.




Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors