Matrix visual with stock balance per week

[HEW]

I am trying to create a matrix where we can see the stock balance per article per week. Below I have made a very simple Excel overview of the tables, I am using.

We have our stock table with one row per article showing the current stock quantity. We have our Inbound table with all purchase orders so be delivered the coming period (multiple rows per article) and our Outbound table with customer orders (also multiple rows per article). Is it possible to create a matrix where the primo stock qty is shown and then a balance for the coming weeks?

I have solved the balance with Inbound and Outbound, but I am not sure how to add the stock....

Thanks a lot in advance.

[v-kelly-msft · Accepted solution]

Hi @HEW ,

Create a data table using :

date = CALENDARAUTO()

Then create a measure as below:

Final Stock 22 = 
CALCULATE(SUM('Stock Table'[Qty]) 
+
 CALCULATE(SUM('Inbound Table'[QTY]),filter('date','date'[Date] <=maxx('Inbound Table','Inbound Table'[Date])))
-
  CALCULATE(SUM('Outbound Table'[Qty]),filter('date','date'[Date] <=maxx('Outbound Table','Outbound Table'[Date]))))

Finally you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490