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.
Helper IIindkitty I was able to upload it here to my onedrive https://1drv.ms/u/s!ApMyUgRWG_6Cjjd7xDi_TJEZgMSF?e=NZPNbb
Community SupportHi, bstark1287
Can you share your expected results for further research?
Best Regards,
Community Support Team _ Eason
- bstark1287
v-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.