illusionek
Board Regular
- Joined
- Jun 21, 2014
- Messages
- 104
Hello
I am trying to modify Days of Supply function that was provided in the below thread but I struggle to get correct numbers and I cant figure out why.
Calculating days of supply using DAX...
I have provided below link to sample file with my attempt on this Dax, I would expect to see below results but as you can see on the file I am getting completely different numbers and have no idea why.
In a nutshell, Days of Supply should look at stock w/c 10th Apr and then compare it vs Demand from w/c 17th Apr onwards to determine no of days stock will last. Number I am getting on my excel file dont seem to match anything I would expect to see.
days of supply sample.xlsx
I am trying to modify Days of Supply function that was provided in the below thread but I struggle to get correct numbers and I cant figure out why.
Calculating days of supply using DAX...
I have provided below link to sample file with my attempt on this Dax, I would expect to see below results but as you can see on the file I am getting completely different numbers and have no idea why.
In a nutshell, Days of Supply should look at stock w/c 10th Apr and then compare it vs Demand from w/c 17th Apr onwards to determine no of days stock will last. Number I am getting on my excel file dont seem to match anything I would expect to see.
days of supply sample.xlsx