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
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.  

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,

  • 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.