Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!!!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |