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 IIbstark1287 Not a problem. Have you built Power BI Dashboard (i.e Pbix) file. If yes, can you share through Google drive/One Drive?
Helper III am sorry but I am unable to share due to security settings. I tried just copying and pasting into a dummy powerbi file to attach here but I am not able.
- indkitty
You cannot add here. Share it with Google Drive/One Drive.
- bstark1287
indkitty I was able to upload it here to my onedrive https://1drv.ms/u/s!ApMyUgRWG_6Cjjd7xDi_TJEZgMSF?e=NZPNbb
- indkitty
Hi bstark,
I have built using the data posted.
for motor stock runouts on 31/07/2022 (partial competion of orders).
for alternator
starting inventory itself is 0, it can only run on 21/07/2022 with remaining qty. then following orders are blank.
Let me know if this is what you wanted.