Forum Discussion
Sum 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.
Hi bstark,
I think required qty is missing production schedule.
indkitty apologies it was there, it was just formatted in a way it was tough for me to even discern. I have added columns in between other values to make it easier to read. Thank you for letting me know!
bstark1287 Not a problem. Have you built Power BI Dashboard (i.e Pbix) file. If yes, can you share through Google drive/One Drive?
I 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.
