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.

Regular Visitor

Inventory management (actuals and forecast combined)



I'm trying to create the following table in PowerBI. It should work as following:

1. Starting Inventory20.00025.00035.00025.00035.00040.00045.00055.00045.00025.00045.00035.000
2. Production10.00020.00015.00030.00040.00050.00040.00030.00040.00040.00030.00025.000
3. Sales (forecast)5.00010.00025.00020.00035.00045.00030.00040.00060.00020.00040.00030.000
4. Closing Inventory25.00035.00025.00035.00040.00045.00055.00045.00025.00045.00035.00030.000


1. Starting inventory = StockCount[StockCount] if the month is in the past and it should be equal to the previous month Closing Inventory for the future.


2. Production = Production[Production]

3. Sales (forecast) = Sales Actuals[sales(actuals)] if the month is in the past and it should be Sales Forecast[sales(forecast)] if the month is currently active or in the future.


4. Closing Inventory = Starting inventory + Production - Sales (forecast)


I can't share the PBIX file here yet, since I am a fairly new member. However, I can share the file by WeTransfer:

Community Support
Community Support

Hi  @tonvhemert3 ,

You can view the contents of the following PBIX file:



Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Liu Yang,


Thanks for the post. However, this is not really what I am looking for. It should be a table in the "Report view" and if future values get added, it should work as well.


Kind regards,


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