I have been working on a series of measures to determine how many weeks my inventory is expected to last when paired with a weekly sales forecast.
I have a starting or current inventory quantity and an estimated forecast by week.
I created a measure to calculate the running total of the forecast quantity:
then another to invert the running total:
and then another measure to calculate the sum of the forecast against the current inventory quantity over each week listed in the forecast (realizing I could probably combine these two into one but trying to piece this all together step by step):
|SKU#||Forecast Date||Sum of Forecast Quantity||ForecastQTYRunningTotal||ForecastInv||InvRemaining||Is_InvRemaining_+|
Solved! Go to Solution.
@dgwoodard , Try a measure like
var _tab = addcolumns(summarize(Table, Table[SKU#], Table[Forecast Date), "_1",[InvRemaining])
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.