Forum Discussion
Helper IISum up columns based on date
Hi @bstrak1287
Refer to below as the value displayed -13 for alternator.
Logic used
current inventory (add a date column which can be 1 day less (Minimum value) than your purchase order/sales order).
Make one table with all data included as below.
current inv - Inital stock.
purchase order - Incoming qty
Work/sales order - consumption.
Create a data table 1 day earlier (as initial stock) and last date as maximum of (work order / purchase order).
You can download the file from below and work around.
https://drive.google.com/file/d/1Bl5qSBtGrnHRhEgN9Sn1kfgQp1gHHFuV/view?usp=sharing
Refer to Enterprise DNA, SQLBI for Inventory dashboard.
Let me if this solution is accepted.
Community SupportHi, bstark1287
Can you share your expected results for further research?
Best Regards,
Community Support Team _ Eason
Helper IIv-easonf-msft I would like something very similar to the attached below. I have a slicer for the date which affects a custom measure (unrestricted stock - production schedule demand + open requisition orders). I would like to add a drill through to the part # that would show the production orders creating the cumulative total.