Forum Discussion

Wcys02's avatar
Wcys02
Frequent Visitor
2 years ago

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...
Need Help
Wcys02's avatar
Wcys02
Frequent Visitor
2 years ago

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's avatar
Fowmy
Icon for Super User rankSuper User
2 years ago

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.  

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    2 years ago

    Wcys02 

    Let me have a look at time later and get back to you.

  • Wcys02's avatar
    Wcys02
    Frequent Visitor
    2 years ago

    Link to the revised file with an additional date column in both excel and PBI:
    https://we.tl/t-Wm57l4fqco

    Thanks,