Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
dats
Resolver I
Resolver I

Caclulating Inventory based on initial Inventory

Dear PowerBi Community,

 

I have a retailer sales table containing data from anuary 2020 to June 2023:

 

-purchased product per retailer/month

-sold products per retailer/month

-initial inventory per retailer/ based on January 2020

 

Basically I would like to calculate a running total inventoy based on the initial inventor and latest purchased and sold products

The issue is that  I cannot get the correct running total calculation(Column: my calculation). I beleieve it is a context issue.

 

Year MonthPurchased goodsSold goodsDeltaInitial InventoryMY calculationneeded solution
2020 Jan52371010
2020 Feb523 313
2020 Mrz523 316

 

Can anybody help out on this? 

 

kr,

dats

 

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.