Hi Team,
I'm wondering if it's possible to create a DAX formula that will calculate days of supply, as shown in the example below:
<tbody>
</tbody>
It is possible to do it in Excel, but it relies on data being arranged in a crosstab in order for the formula to be able to calculate the forward buckets of demand covered.
Bit of a long shot I'm thinking, but I thought I'd ask the question in case anyone has any bright ideas.
Cheers,
Matty
I'm wondering if it's possible to create a DAX formula that will calculate days of supply, as shown in the example below:
Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | |
Demand | 10 | 15 | 12 | 5 | 8 | 20 | 15 | 21 |
Supply | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 30 |
Opening Stock | 50 | 40 | 25 | 13 | 58 | 50 | 30 | 15 |
Closing Stock | 40 | 25 | 13 | 58 | 50 | 30 | 15 | 24 |
Days of Supply | 28.0 | 21.0 | 14.0 | 26.0 | 19.0 | 12.0 | 5.0 | 0.0 |
<tbody>
</tbody>
It is possible to do it in Excel, but it relies on data being arranged in a crosstab in order for the formula to be able to calculate the forward buckets of demand covered.
Bit of a long shot I'm thinking, but I thought I'd ask the question in case anyone has any bright ideas.
Cheers,
Matty