Forum Discussion
Data Model Retail Business (help!!)
Hi Anonymous,
Sure thing, link here, link to pbix.
In words essentially what i created where three calculated columns in the F_Stock Table
[Coverage Days] = stock / sales *30
[Coverage Label] = Case statement to assign correct label based on [Coverage Days] Value
[Coverage Index] = Case statement to assign correct order for [Coverage Label] based on [Coverage Days] Value This value is used as the sort by value for the [Coverage Label] Column
Once the Calculated Columns are available you can create the matrix you are looking for
richbenmintz Uau this looks amazing!!
In onder to understand better the solution:
Is is possible to explain why did you make the [coverage days_], [coverage index_] and [coverage label_] also on the "F_sales"? Any reason or this is not used? From my understanding it seems not to be used by the model.
At the same time, it would be feasible to add to more columsn on the F_Stock with sales of "month n-1" and "month n-"2? And at the same time to adapt the coverage days formula from "stock / sales" to "stock / average sales (month n, n-1,n-2)" (i make a picture - below - in order to facilitate what im triying to say)
If i get your logical, i can adapt it to my reality.
Again and again...all my respect and thanks for your extraordinary help!
André