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])
Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.