cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mordonez
Frequent Visitor

stock calculation

Hello  , i have a simple problem but i cant find a simple answer :
I tried to look on older posts but i couldnt find a solution to mi problem : 

 

I have a model where i have : 

Sales in : the sales from mi compañy to resellers

Sales Out: the sales from the resellers to end users

Initial stock : the stock on hand reported by the resellers at 01/01/2020 

 

I need to calculate the stock by  adding the sell in and sustracting the sell out : 

 

Example : 

 

 

initial stock  productA in reseller A =10000 to that value i have to add the sell in and sustract the sell out 

 

01/01/2020 stock=10000

sales in jan/2020=5000

Sales out in jan/2020=7000

stock in feb/2020= 10000+5000-7000=8000<then , this should be the initial stock in february so :

sales in feb/2020=2000

sales out feb/2020=5000

stock in march/2020=8000+2000-5000=5000 , and so on 

 

i have a sales in table with dates and sku and reseller number , also i have a sales out table with the same dimentions , calendar table , and product table

 

TY!!!

 

1 REPLY 1
Anonymous
Not applicable

Please place a link to a model with your tables. Just anonymize the data that can't be exposed. I don't want to create the tables you're referring to by hand...

Best
D

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors