Forum Discussion
Inventory Forecast Recursive Calculation
Hi all, I'm trying to create a DAX measure that populates "forecasted remanining inventory". I have gone through Gerhard's blog on recursive calculation, but it talks about compound interest and ...
Yes you're correct
Hi,
If inventory will be manually input every month and there is also sales for every month, then the invenory will simply be
=[inv qty]-[sales qty]
where inv qty and sales qty are simple SUM() measures.
Hi Ashish,
I hope you can tell from icwiener's post that it really isn't so straightforward. The measure you suggested will not work for future months where there is no value for the inventory. that's why I'm trying to figure out a measure to calculate the forecasted inventory value.