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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

You mention that Brnach 1 Model B is a problem - you expect the answer of that to be 7.  I see some other lapses there as well.  For e.g. branch 2 Model E.  Shouldn't the answer of that be 7 (in the 7th month, the opening inventory would be consumed).  It would be ideal if you could show the exact expected result of each Branch and model combination.

Lastly, could you ensure that in each table you have a Date column.  If that is not possible, please have a month and year column in each table (from where we can create a Date column).

Wcys02's avatar
Wcys02
Frequent Visitor
2 years ago

Hi, yes you are right, there are a few lapses, and generally the DAX code that I've written does not give me the outcome I want. I've created an excel with the same format and expected resutls by each branch and model at the different levels (https://we.tl/t-QYLx2WyuNU). As for the date column, only the sales plan has a date/timeline, in which I plan to use month number to reference the months within a year for ease of calculating the month cover.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Share both raw datasets with a Date column in both tables.