Forum Discussion
Show Date When Available Stock Drops Below Zero
Hi all
After some help here as i'm struggling.
I have a BI Dashboard i'm working on - main structure and relationships below.
SQL Query 1:
SKU Code (linked to Query 2 one to many)
Available Stock
SQL Query 2:
SKU Code (linked to Query 1 many to one)
Week Commencing Date linked to Date table many to one)
Forecast for Week
Date Table in BI
Date
Week Commencing Date (linked to Query 2 one to many)
Basically from here i want to calculate the Date (Week Commencing or estimated date based on average) the Avalable stock - Current Forecast drops below zero - to give a days cover type measure.
No inbound production is required for this.
Happy to field any questions etc and thanks for the help in advance.
2 Replies
hi amitchandak
these are helpful but don't really work in my case - these are tracking single inventory not multiple SKUs, the middle link even has someone trying to do it with multiple skus and with no luck.
Do you or anyone else have more resources or other suggestions?
Thanks
