Forum Discussion
Stock Cover Months
Hi, I have the following measure to calculate the stock months cover by each model and branch: Stock months cover = VAR s = SUM(Stock[Stock]) VAR w = 1 VAR t = FILTER ( 'Sales Pla...
Hi, apologies for not being clear. I basically want the reference index month to be dynamic based on the current month. For example, in December where the index/month number would be 12, it will start to calculate the stock cover using the sales plan based on index month 12 and onwards.
Excel link with example:https://we.tl/t-LJwkepZ63O
Hope this clarifies,
Many thanks
- Fowmy
Super User
Wcys02
In your Excel file, the data is spread only across 12 months per branch and model, the required scenario cannot be tested without having data for 24 months, please attach a files (Excel and PBI) , with proper dates instead of month numbers.Link to the revised file with an additional date column in both excel and PBI:
https://we.tl/t-Wm57l4fqco
Thanks,