Forum Discussion
Funk-E-Guy
Helper II
Helper IIAvoiding Circular Discrepancies for Col A = Col B (last row) and Col B = Col A (current row)?
My goal: To use DAX to calculate Ending Inventory as a function of MAX(0, Beginning Inventory + Receipts - Forecast), for every day and every SKU. My Issue: I do not know how to lookup the previo...
Funk-E-GuyHelper II
Helper IISorry, I gave up trying to find a solution that would allow me to forecast going to 0 and receiving the full amount in the future. Anything I could do in one function can only take me to 0, or negative, in which case the cumulative receipts don't add up properly.
I ended up settling for just keeping the visibility of when I'd go out of stock, and anything past that becomes an unknown.
Oh ok.. am still struggling to just use the previous week balance into next week blance calculation. How did you achieve that? Can you share the file or the measure logic please?